Programming SQL Server .NET

As mentioned on Day 1, in its initial release, ADO.NET splits the two main programming models encapsulated in the ADO Recordset object into two objects. The DataSet is analogous, although more powerful, than a disconnected Recordset, whereas the data reader is analogous to using a firehose cursor to provide forward-only, read-only, connected access to data. However, the ADO Recordset was also used to access data that remained on the database server through dynamic, server-side cursors. Late last year, Microsoft revealed how server-side data access is to be restored—and indeed greatly expanded—in ADO.NET when the next ...

Get Sams Teach Yourself ADO.NET in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.