DataAdapter vs SqlDataAdapter

Question

What is the difference between DataAdapter and SqlDataAdapter? Please explain the scenarios where to be used DataAdapter or SqlDataAdapter.

Ehsan Sajjad · 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!

Rajeesh Menoth · Answer

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

Rajkiran Swain · Answer

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