Types of DataAdapter in ADO.NET


This object is a popular dataset object with results from a Data Source. It is a special class used to bridge the gap between the disconnected Dataset objects and the Physical data source.

Types of DataAdapter:

When you use DataAdapter, you can specify the portions of the data required from the data source by using a SQL statement or stored procedure. The same logic applies when you’re trying to implement the changes from the DataSet into the Data Source. There are two types of DataAdapter are:
1. OleDbDataAdapter: It can be used with any data source that has an OLE DB provider.

2. SqlDataAdapter: SqlDataAdapter is only for SQL Server. It is much more efficient.