What is ado.net
Ado.net is a set of software components that expose data access service for .net framework programmers. Basically it is a part of the base class library in .net framework. Programmers used this for creating database driven applications. Ado.net has two primary parts. Data provider Data set What is the data provider? It is a set of related components work together to provide data in an efficient manner. Data provider means providing data from a data base. Here we use two types of databases. SQL : used for SQL server OLEDB : used for oracle, My SQL, Access Data provider consist 4 main components. Connection object Command object Data reader object Data adapter object What is Data set? This is a disconnected, in memory representation of data. The data is data set can be loaded from any valid data source. Data set is made my data adapter.it has two components as Data table and Data relation. A dataset object represen