Summary
The initiative behind ADO.NET was to reimplement ADO using XML as a flexible and extensible format that is easily transmitted across networks like the Internet. We will talk more about XML and ADO.NET in Chapter 12.
The simple yet powerful revision to ADO in .NET is that the DataSet is disconnected. The benefit is that the client retrieves the data and can perform relevant operations without holding a connection to the database, returning to the database only when changes need to be posted. As you learned in this chapter, you can filter and sort data without requerying the database. You also learned that you have a variety of options, including using DataReader objects for faster forward and read-only data access, using the CommandBuilder ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access