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 ...
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