Summary

Chapter 1 looked at what ASP.NET is, and Chapter 2 looked at what ADO.NET is. This chapter pulled the two pieces together.

In this chapter you learned that the ADO.NET Managed Providers are the bridge from a data store to your data-driven application. The Managed Providers come in two stock flavors: the SQL Managed Provider and the OleDb Managed Provider. The SQL Managed Provider is used to connect directly to a Microsoft SQL Server database (version 7.0 or higher), and bypasses OLEDB to provider better performance. The OleDb Managed Provider is used to connect to non-Microsoft SQL Server databases, such as Access, Oracle, and a host of others.

In this chapter you created connections to a database, built command objects to execute SQL ...

Get Programming Data-Driven Web Applications with 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.