Chapter 18. Advanced ADO.NET Techniques

In This Chapter

• Working with the New Improved DataTable

• Accessing Data Asynchronously

• Updating Data in Batches

• Using the new System.Transactions Namespace

Undoubtedly, ADO.NET has made life a lot easier for developers. It provided a unified means for communicating with relational data sources, whether the source was SQL Server, Oracle, Access, or even XML. In this chapter, you will see some extremely powerful techniques that you can use in your ADO.NET 2.0 programming. You will see some of the improvements made to the DataTable class, as well as how to access data asynchronously, update data in batches, and even how to use the new unified transaction model provided by the System.Transactions namespace.