Managed Providers

Managed Providers are a central part of the ADO.NET framework. They enable you to write language-independent components that can be called from C# and Visual Basic. Currently, Managed Providers come in two types: one for direct access to Microsoft SQL Server 7.0 and higher, and one for accessing data through an OLE DB layer. Both use similar naming conventions; the only difference is their prefixes.

The Managed Provider classes include Connection, Command, DataReader, and DataAdapter. The first two classes provide the same functionality that was found in ADO: creating a connection to a data source and then executing a command. A DataReader has a close resemblance to a read-only, forward-only recordset that is very optimized. ...

Get Special Edition Using® Microsoft® ASP.NET 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.