DataAdapter vs SqlDataAdapter

Sujeet Singh

What is the difference between DataAdapter and SqlDataAdapter?

Please explain the scenarios where to be used DataAdapter or SqlDataAdapter.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ehsan Sajjad9y ago
Accepted answer
The DataAdapter is more general class for retreiving and saving data to and from database while SqlDataAdapter is more specific implementation for SQL Server database, so if we know we will be interacting with Sql Server databses then the preferred class in SqlDataAdapter which will be more performant than DataAdapter.

You can read the details of both at following MSDN links:

https://msdn.microsoft.com/en-us/library/system.data.common.dataadapter(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter(v=vs.110).aspx

Hope it helps!
Rajkiran Swain9y ago
http://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1
Rajeesh Menoth9y ago
Hi,

DataAdapter is like a bridge between DataSet and database. This dataadapter object is used to read the data from database and bind that data to dataset.
SqlDataAdapter
Lets you close the connection as soon it's done loading data, and may even close it for you automatically
All of the results are available in memory
You can iterate over it as many times as you need, or even look up a specific record by index
Has some built-in faculties for updating back to the database
Reference
https://stackoverflow.com/questions/1676753/sqldataadapter-vs-sqldatareader

http://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1