ADO.NET is the main data access system that c# uses to work with the data stored in the tables of databases. It uses a disconnected data architecture, which means that you can work with a copy of the data in the database. In a traditional data connection, the application stays connected with the databases even when the application is not functioning; thereby, wasting databases resources. In ADO.NET, the application connects to a database when it needs to pass some query to the databases and disconnects immediately after the result of the query is saved locally. Therefore, disconnected data architecture is maintained in ADO.NET to reduce the load on servers.
The functioning of an ADO.NET application is implemented by using the classes that are found in System.Data.dll and these classes are integrated with the Extensible Markup Language (XML) classes found in System.Xml.dll. Some of the important features of ADO.NET are as follows
⦁Supports SQL Server 2014 SqlClient: Provides support for new features of SQL Server 2014 Database Engine by introducing. NET Framework Data Provider for SQL Server (System.Data.Sqlclient). You need to instal. NET Frameword 3.5 SPL (or later) to use the SQL Server 2014 SqlClient with your. NET application.
⦁Language-Integrated Query (LINQ): Simplifies querying by eliminating the need of using a separate query language. LINQ to ADO.NET is a LINQ technology, which enables querying in ADO.NET by using the LINQ programming model. LINQ to ADO.NET consists of two related features: LINQ to DataSet and LINQ to SQL. LINQ to DataSet facilitates faster querying of data on the content of a dataset and LINQ to SQL enables you to directly query SQL Server databases.
⦁LINQ to DataSet: Provides LINQ capabilities for disconnected data (the data that is stored locally) stored in a dataset. LINQ to DataSet makes it easier and faster to query data cached in a DataSet object. DataSet objects are important as they allow users to use a copy of the data stored in the tables of a database, without actually getting connected to the database. The LINQ to DataSet features enables you to work more productively
⦁LINQ to SQL: Provides a runtime infrastructure to manage relational data as objects. You can use the LINQ to SQL technology to transalte a query into a SQL query and then use it to query data contained in tables of a SQL Server database. LINQ to SQL supports all the key functions that you like to perform while working with SQL, that is, you can insert, update, and delete information from a table.
⦁Entity Framework: Allows you to access the data from a database through an object model instead of a relational model. The Entity Framework was first introduced in. NET Framework 3.5 It provides you set of Entity Data Model (EDM) functions that help you to write less access code, reduce maintenance, make the structure of data-friendly, and persist the data. You can use a data provider called EntityClient and a language called Entity SQL to interact with the Entity Framework directly.