Conclusion
The .NET data access subsystem is made of two main subtrees—the managed providers and the database-agnostic container classes. ADO.NET managed providers are a new type of data source connectors and replace the COM-based OLE DB providers of ADO and ASP. As of this writing, the .NET Framework includes two native providers—one for SQL Server and one for Oracle—and support for all OLE DB providers and ODBC drivers. Third-party vendors also support MySQL, DB2, and Sybase, and they have alternate providers for Oracle.
A managed provider is faster and more appropriate than any other database technology for data-access tasks in .NET. Especially effective with SQL Server, a managed provider hooks up at the wire level and removes any sort of abstraction ...
Get Programming Microsoft® ASP.NET 3.5 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.
