Introduction To Ado.Net

What is ADO.NET ?

It is a very rich set classes used to interact with Datasource like XML and Data base files and this data can consumed in any application of .net

• Very Rich Set of classes to communicate with DB and other Data Sources
• Set of .Net Libraries which provides interaction with DB
• Initially it was a library But today it is a Open Source Framework
• System.Data is the Main source
• introduced in .NET 1.0 as ADO.NET 1.0
• But the version 1.0 and Version 2.0 are not success because lots of                                       dependent  on Activx Data Base
• The First Successful version ADO.NET 2.0
• the next version is ADO.NET 3.5 here LINQ to SQL is introduced
•  And the next version ADO.NET4.0 Here they used Entity Frame Work
• form the version Ado.Net 7.0 onwords we can conect with Hadoop and Cloud
• ADO.Net Used As to connect  the front-end user interfaces and the back-end database.
• The ADO.net classes are found in Sysyem.Data.DLL 
• Ado.net are integrated with the XML classes and found in System.Xml.DLL

Evolution of ADO.NET :

• The Evolution of ADO.NET is in 6 ways

            --> DDA -->DAO-->ODBC-->OLEDB -->DAO -->RDO -->ADO -->ADO.NET

• DDA -> Dynamic Data Access
• ODBC -> Open Data Base Connectivity(Drivers)
• OLEDB -> Object Linking And Embedding Database(Data Provider)
• DAO -> Data Access Object 
• RDO -> Remote Data Object
• ADO -> ActiveX Data Object
• ADO.NET -> ActiveX Data Object for .NET

What is Data provider?
Ado.Net Data Providers are class libraries that allows to interact the DB.

What are the Data Providers?
Data Providers are 4  they are
                          1)Connect to Data Base
                          2) Preparing the SQL Command
                          3)Execute The Command
                          4)Retrieve and Display the result