Programming Microsoft ADO.NET 2.0 Core Reference

Build your expertise as you move beyond the basics—and delve into the essential topics of programming with ADO.NET 2.0. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C# and Visual Basic to help advance your mastery of developing database applications for Microsoft Windows and the Web.

Discover how to:

• Work with design-time data access features in Microsoft Visual Studio 2005
• Use Microsoft .NET Framework 2.0 data providers to connect to databases
• Build connection strings and enable connection pooling
• Execute queries, including parameterized and asynchronous queries, and retrieve their results
• Create DataSet objects to work with offline data and explore common usage scenarios
• Use the new Common Language Runtime features and XML data type in Microsoft SQL Server 2005
• Generate logic and use stored procedures for simple to advanced updating scenarios
• Design Web applications with new data access features in ASP.NET 2.0—including code-free data-binding capabilities

PLUS—Get Visual Basic and C# code samples, and a Microsoft .NET Data Provider on the Web

Extend your expertise as you move beyond the basics — and delve into the essential topics of programming with ADO.NET 4. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C#® and Visual Basic® to help advance your mastery of developing database applications for Windows® and the Web.

Discover how to:

• Connect to databases directly from your application to retrieve and manipulate data
• Use ADO.NET 4 to retrieve server-generated values
• Interact with an applications UI with data binding
• Model and interact with data using ADO.NET Entity Framework
• Query Microsoft SQL Server® databases with LINQ to SQL
• Manage datasets from a variety of databases with LINQ to DataSet
• Use ADO.NET as an offline data cache for your application

David Sceppa is a contractor who spent 14 years working for Microsoft on the SQL Server® team at Microsoft. He is an expert on ADO.NET. As a former technical lead in the Microsoft Developer Support group, he helped customers build database applications with Visual Basic and Microsoft Visual FoxPro®. David is MCSD certified in Microsoft .NET and has a background in teaching. He has written several books on ADO.NET.

• Chapter 1: Overview of ADO.NET
• Chapter 2: Building Your First ADO.NET Application with Microsoft Visual Studio 2005

• Chapter 3: Connecting to Your Database
• Chapter 4: Querying Your Database
• Chapter 5: Retrieving Data Using SqlDataAdapter Objects

• Chapter 6: Working with DataSet Objects
• Chapter 7: Working with Relational Data
• Chapter 8: Sorting, Searching, and Filtering
• Chapter 9: Working with Strongly Typed DataSet Objects and TableAdapters
• Chapter 10: Submitting Updates to Your Database
• Chapter 11: Advanced Updating Scenarios
• Chapter 12: Working with XML Data

• Chapter 13: Building Effective Microsoft Windows—Based Applications
• Chapter 14: Building Effective Web Applications
• Chapter 15: SQL Server 2005 Common Language Runtime Integration

• Appendix A: Using Other .NET Data Providers
• Appendix B: Samples and Tools
• About the Author