ADO.NET examples and best practices for C\# programmers. Incl. 1 CD-ROM (Q2784230)

The book presents ADO.NET with C\#, .NET Framework, and how Visual Studio.NET helps to build ADO.NET-based applications. The book contains ten chapters of whom the first is an introduction.NEWLINENEWLINEChapter 2, `ADO.NET - Getting Connected', discusses how to establish a connection in .NET using different .NET Data Providers and traditional ADOc Connection object. In chapter 3, `ADO.NET Command Strategies', it is shown how to use Visual Studio to construct optimal SQL queries that are then executed within ADO.NET. Chapter 4, `ADO.NET DataReader Strategies', explores DataReader properties that allows to execute low-level I/O operations. Chapter 5, `Using the DataTable and DataSet', helps to understand the differences and similarities between the ADOc Recordset and the new ADO.NET DataTable and DataSet, whereas the next chapter focuses on sorting, filtering, and finding data after DataSet and DataTable objects have been populated with data. The chapters presented so far described mostly extracting and messaging data from various data sources; chapter 7, `ADO.NET Update Strategies', presents the mechanisms of persisting changes to a data store or transporting DataTable or DataRow data from the memory. Chapter 8, `ADO.NET Constraint Strategies', discusses how ADO.NET has implemented referential and data constraints and also how to specify the relationships between tables in a given database. Chapter 9, `ADO.NET Exception Management Strategies', shows how exceptions are exposed and managed by the .NET Framework. Chapter 10, `ADO.NET and XML', focuses on how to use XML features to process, transform, and transport various data and the ADO.NET support of this language. A companion CD is also supplied with the book.