Provider Architecture
As mentioned on Day 1, “ADO.NET In Perspective,” a provider's main responsibilities include connecting and disconnecting with a data store, performing transaction management, handling exceptions, executing parameterized queries and commands, and then either processing the results directly or interacting with the DataSet object. To that end, ADO.NET provides classes and interfaces in the System.Data and System.Data.Common namespaces that are used as a template for developers building providers to work with specific data stores.
Note
As you look at these common interfaces, you might be wondering why, for the most part, the interfaces such as IDataReader are in the System.Data namespace, but the classes such as DbDataAdapter ...
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.
