Chapter 9. ADO.NET

For many web applications, you will use the DataSource controls and you need not know anything at all about the underlying “plumbing” that interacts with the database. However, most serious commercial applications will have needs that go beyond what a DataSource control can do, and you will then need to dive into the ADO.NET object model to understand how the data source works and how to accomplish more advanced tasks.

To illustrate the utility of understanding the ADO.NET object model, you’ll undertake two tasks in this chapter:

  • Make use of connection-based transactions.

  • Create a business-tier object that mediates between the user-interface level and the database, binding the UI to an instance of ObjectDataSource.

Before you can accomplish either of these tasks, we must back up and examine the ADO.NET object model.

Get Programming ASP.NET 3.5, 4th Edition 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.