As with all of the O'Reilly Cookbooks, ADO.NET 3.5 Cookbook gives you all of the solutions you need without getting bogged down in a lot of theory. Updated for Visual Studio 2008, SQL Server 2008, and the .NET framework 3.5, there are over 200 coding solutions giving you many best practices for real-world problems.
While it may not go deep in theory, it does, while addressing your immediate needs, gives you a firm grasps of the underlying concepts of the ADO.NET technology while helping you learn as you go. The ADO.NET 3.5 Cookbook is 980 pages in length and divided into 12 chapters that cover specific aspects of the ADO.NET platform.
Chapter 1, "Connecting to Data," examines how to connect to various data sources using ADO.NET. This involves working with connection strings, working with security issues, how to build a connection string at runtime, and connection pooling. Chapter 2, "Working with Disconnected Data Objects," looks at working with DataColumns, DataTables, DataSets, DataRelations, as well as other topics for working with disconnected data. You will also learn about strongly typed DataSet objects and how to customize aspects of them.
Chapter 3, "Querying and Retrieving Data," will show you how to get data and schema's using SQL statements, stored procedures, and batched queries. There are solutions here that show you how to work with LINQ, Text files, and Excel Workbooks. Chapter 4, "Searching and Analyzing Data," lets you find and filter records in views and tables. You will see how to use Common Table Expressions, how to retrieve ranked result sets, and how to invoke a function for each row in a result set.
Chapter 5, "Adding and Modifying Data," focuses on inserting and updating data, and even how to use messaging to update data. You will look at the use of GUID's, master-detail records, and how to insert multiple tables using a T-SQL row constructor. Chapter 6, "Copying and Transferring Data," looks at copying data between various disconnected classes as well as between ADO and ADO.NET. You will also examine topics such as merging data, encrypting data, and securing login credentials.
Article comments