ADO.Net :-

• ADO.Net is the native driver designed by Microsoft for .Net technology used to interact with middleware or database

• Without ADO.Net we cannot write database programming code in .Net

• ADO.Net is a set of classes that expose data access service to .Net programmer

• ADO.Net provides set of components for creating distributed, data sharing applications

• ADO.Net is an integral part of the .Net framework which provides access to relational, XML and application data

• ADO.Net provides consistent access to data sources such as SQLServer and XML, and to data sources exposed through OLEDB and ODBC

• ADO.Net includes .NET Framework data provides for connecting to a database, executing commands, and retrieving results

• The ADO.NET classes are found in System.Data.dll, and are integrated with the XML classes found in System.Xml.dll

• ADO.Net supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers

• Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, handle, and update the data that they contain

• ADO.Net separates data access from data manipulation into discrete components that can be used separately or in tandem

• Those results are either processed directly, placed in an ADO.Net Dataset object in order to be exposed to the user in an ad hoc manner, combined with data from multiple sources, or passed between tiers. The Dataset object can also be used independently of a .NET Framework data provider to manage data local to the application or sourced from XML

• ADO.NET provides functionality to developers who write managed code similar to the functionality provided to native component object model (COM) developers by ActiveX Data Object (ADO)

Benefits of ADO.NET:-

ADO.NET offers several advantages over previous versions of ADO and over other data access components. These benefits fall into the following categories

1. Interoperability
2. Maintainability
3. Programmability
4. Performance
5. Scalability