As we were previously discussed about How to access SQL database though LINQ. Now we will talk about another way to connect to a SQL database using ADO.Net. ADO.net is an acronym for Advance Data Object (ADO.net) is a new database technology used by .Net platform. ADO.Net is a set of classes that provides the services like data access and data managing. It has easier coding as well as fast and efficient than LINQ. It supports both connected and disconnected modes of data access. Firstly ADO (ActiveX Data Object) was introduced for data access from web pages it relies on COM. But ADO wasn’t really efficient working with databases because it can hold one data source at a time. So, ADO.Net was introduced which relies on managing providers defined by the .Net CLR (Common Language Runtime). ADO.Net creates connection with various databases and integrates all of them. ADO.Net works as a bridge between front end and back end database. The main feature of ADO.net that it provides rich set of libraries to create data sharing and data distributed applications. For accessing data it uses some ADO Objects like connection and command objects which include Dataset, DataReader and DataAdepter etc.
