Chapter 21. ADO.NET Part I: The Connected Layer

As you might expect, the .NET platform defines a number of namespaces that allow you to interact directly with machine local and remote relational databases. Collectively speaking, these namespaces are known as ADO.NET. In this chapter, you'll learn about the overall role of ADO.NET, then move on to the topic of ADO.NET data providers. The .NET platform supports numerous data providers, each of which is optimized to communicate with a specific database management system (e.g., Microsoft SQL Server, Oracle, and MySQL).

After you understand the common functionality provided by various data providers, you will then look at the data provider factory pattern. As you will see, using types within the ...

Get Pro C# 2010 and the .NET 4 Platform, Fifth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.