ADO.NET Part I: The Connected Layer
As you would expect, the .NET platform defines a number of namespaces that allow you to interact with machine local and remote relational databases. Collectively speaking, these namespaces are known as
ADO.NET. In this chapter, once I frame the overall role of
ADO.NET, I'll move on to discuss 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 (Microsoft SQL Server, Oracle, MySQL, etc.).
After you understand the common functionality provided by various data providers, you will then examine the data provider factory pattern. As you will see, using types within the