Types of DataAdapter in ADO.NET

DataAdapter

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.