Fundamentals of ADO.NET

Microsoft split ADO.NET into two camps: the SqlClient camp and the OleDb camp. The SqlClient camp represents Microsoft SQL Server 7.0 and higher, and the OleDb camp handles everything else, including Microsoft ACCESS, Microsoft SQL Server 6.5, Oracle, UDB, Sybase, Informix, and others. The notion of a camp refers to database providers. In addition to the two-camp model, Microsoft's .NET Framework supports extending ADO.NET by allowing vendors to implement their own provider classes. The result is that any database supplier could create its own custom provider classes for ADO.NET.

ADO.NET in general is made up of the System.Data and System.Xml namespaces. Classes that are general to ADO.NET are typically found in the

Get Visual Basic® .NET Power Coding 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.