Data Providers
ADO.NET data providers[1] allow you to execute commands directly against the data source. Functionality is exposed directly without intermediary objects such as an OLE DB (object linking and embedding database) that stand between ADO and the data source. The .NET DataAdapter class models a data source as a set of database commands and a connection to that data source. Differences between data sources are not hidden by generic interfaces. The OLE DB data provider allows for nested transactions with data sources that support that functionality; the SQL Server data provider does not.[2]
[1] .NET data providers are what used to be called in the beta literature managed providers. You may still see them referred to by that term.
[2] There ...
Get Programming PERL in the .NET Environment 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.
