Benefits of using the ADO DOT NET
Explain the benefits of using the ADO.NET in .NET 4.0?
Expert
The benefits of using the ADO.NET in .NET 4.0 are:
i. SqlClient Supports SQL Server 2008 : Which Specifies the opening of .NET Framework version 3.5 Service Pack (SP) 1, .NET Framework Data Provider for SQL Server (System.Data.SqlClient namespace) comprises all the latest features which makes it full compatible with SQL Server 2008 Database Engine.
ii. LINQ to DataSet – permits us to execute LINQ queries for the disconnected data stored in the dataset. LINQ to DataSet allows us to query data which is cached in the DataSet object. DataSet objects allow us to utilize a copy of a data stored in tables of the database, without actually connected to a database.
iii. LINQ to SQL - Allows us to generate queries for the data stored in the SQL server database in .NET application. We can use LINQ to SQL technology to interpret a query into the SQL query and then use it to regain or control data contained in the tables of the SQL Server database. LINQ to SQL supports every key function which we like to carry out while working in SQL, i.e., we can perform functions like inserting, updating, and deleting information from the table.
iv. ADO.NET Data Platform – It specifies that with release of the .NET Framework 3.5 Service Pack (SP) 1, the Entity Framework 3.5 was introduced which provides the set of Entity Data Model (EDM) functions. The functions are supported by every data providers; thereby reducing amount of coding and maintenance in the application. In .NET Framework 4.0, several latest functions, like mathematical, string, date/time and aggregate functions have been included.
v. Language-Integrated Query (LINQ) – It includes local data-querying capabilities to .NET languages with the use of syntax similar to SQL. This means that LINQ simplifies querying by eliminating the requirement to use the separate query language LINQ is an innovative technology that was introduced in .NET Framework 3.5.
State the difference between Managed and Unmanaged Code?
Explain Windows services?
Explain keywords by giving example.
Write the differences between HTML and XML.
Explain the role of CLR in .NET Framework.
Briefly describe about keywords also give example.
What is the function of Orientation property in a Menu control?
How we can prevent users of the application from editing a text in ComboBox controls in the .NET 4.0?
Write three general properties of every validation controls?
State some of the use of ScriptManager control in the AJAX?
18,76,764
1950118 Asked
3,689
Active Tutors
1417956
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!