CODEWITHSUNDEEP
c#ado.netcomparison
Pankouri
Pankouri

Reputation: 676

Comparison of ADO.NET connected and disconnected classes

Pros and cons and Usage

I have been preparing myself for an interview for the post of software developer in .net platform. For database related issues, I have to to a point about the connected ans disconnected classes of ADO .NET. I have read several articles but still not getting a perfect picture of those two terms. Hence, here I am, to the best place to get a concrete ans. Can any one explain me the pros and cons and the usage scenarios?

Upvotes: 0

Views: 2850

Answers (1)

Brain2000
Brain2000

Reputation: 4894

A DataReader uses a connected architecture since it keeps conneection open until all records are fetched.

A DataSet uses a disconnected architecture since it reads all records at once and closes connection afterwards, and the records are available after the connection is closed.

http://www.sitepoint.com/dataset-datareader

Upvotes: 2

Related Questions