Chapter 7, "Maintaining Database Integrity," is explored using both manual and automatic truncations as well as DBMS transactions from ADO.NET. Here you will see how to handle concurrency errors, set isolation levels, and resolve data conflicts. Chapter 8, "Programmatically Working with Data in .NET Windows and Web Forms User Interfaces," focuses on programmatically binding simple and complex data to Web Forms and Window Forms.
Chapter 9, "Working with XML Data," shows you how to use XML with ADO.NET. Here you will work with the six namespaces that handle XML data and see how to both save and load XML data. Chapter 10, "Optimizing .NET Data Access," begins by looking at where the bottlenecks are at and then looks at asynchronous processing, caching, paging, batching and other methods to improve performance.
Chapter 11, "Enumerating and Manipulating Database Objects," now looks at methods to get schema information and metadata from databases, manage database objects, and enumerate installed database providers and drivers. Chapter 12, "SQL Server CLR Integration," explores the use of CLR in the database engine. This gives you the ability to use something similar to the extended stored procedures available in prior versions but, by using code access security (CAS), it can be done in a much safer and more controlled environment.
As with all of the Cookbook series, ADO.NET 3.5 Cookbook , makes a great resource for just about any .NET developer and while the title says ADO.NET 3.5 Cookbook , the most of recipes in this book will work pretty well with versions of ADO.NET 2.0 and greater.
ADO.NET 3.5 Cookbook is a very complete book with a lot of examples that cover just about any aspect of working with data under .NET. There are a lot of program examples and its layout of stating a problem, defining a solution and then discussing the solution, works very well. If you need to have a problem solving reference for working with ADO.NET, then I very highly recommend this book.
Article comments