Benefits of using the ADO DOT NET

Question

Explain the benefits of using the ADO.NET in .NET 4.0?

Answer 1

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.