Programming Data-Driven Web Applications with ASP.NET

Chapter 3. ADO.NET Managed Providers

IN THIS CHAPTER

• The Two Managed Providers

• Managed Connections

• Managed Commands

• The DataReader

• Managed Commands with Stored Procedures

• The DataAdapter

• Table and Column Mappings

• Summary

In the last chapter, you began looking at how an ASP.NET data-driven solution works. You looked at the ADO.NET object model, and how to build a DataSet dynamically. In this chapter, you'll dig into the two data access Managed Providers offered in ADO.NET: the SQL Managed Provider and the OleDB Managed Provider.

In this chapter, you'll learn the following:

• How the .NET Managed Providers are a bridge from the application, such as an ASP.NET Web Form, to a data store, such as Microsoft SQL Server.

• How to create Managed Connections to connect ...