Saturday, 27 April 2013

What is the difference between DataReader and DataAdapter? | ASP.Net interview questions

=> Data Reader is read only forward only and much faster than DataAdapter.
=> If you use DataReader you have to open and close connection explicitly where as if you use
=>  DataAdapter the connection is automatically opened and closed.
=> DataReader is connection oriented where as Data Adapter is disconnected

No comments: