What are the new features of ADO.NET 2.0? [closed]

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. Closed 11 years ago.

I was asked by interviewer that what are new features of ADO.NET 2.0?

I replied (A) SQLConnection (B) SQL Command (C) Data Adapter, dataset & data reader.

But he said, those featu开发者_StackOverflow社区res were already there in ADO.NET 1.1

let me know if any inputs.

Thanks!

---

MSDN says these are the new features.

---

see here: http://msdn.microsoft.com/en-us/library/ex6y04yf(VS.80).aspx The person was probably looking for Disconnected Classes

---

Well, "he" as in "he said" is right, but MS sure made them work better, faster, and with less coding effort in v2.0.

For one thing, DataReader could be loaded directly into a DataSet or DataTable, which simplified things a lot. To me the other biggies were the addition of asynchronous BeginExecuteXxxx() & EndExecuteXxxx() calls along with allowing more than one pending request on a connection, and direct support for reading data in a paged manner without having to write a stored procedure for each place you had a large data set that needed to be paged.