Chapter 10. 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. On the other hand, most serious commercial applications will have needs that go beyond what the 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:

• Utilize 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.