Interview Questions On ADO.NET :: What is the difference between Data Reader and Data Adapter?

Ram Pothuraju

Data Reader is read only forward only and much faster than Data Adapter.

If you use Data Reader you have to open and close connection explicitly where as if you use Data Adapter the connection is automatically opened and closed.

Data Reader  expects connection to database to perform any operation on data where as Data Adapter is disconnected

Post a Comment


Post a Comment (0)