Microsoft ADO.NET 4 Step by Step

Description

Teach yourself the fundamentals of ADO.NET 4 -- one step at a time. With this practical, learn-by-doing tutorial, you get the clear guidance and hands-on examples you need to start creating datacentric applications for Windows(R) and the Web.

Discover how to:

* Connect to external data sources, including databases and other data formats
* Use ADO.NET Entity Framework to interact with underlying data stores
* Build Entity Framework models with graphical design tools in Microsoft Visual Studio 2010
* Analyze information stored in ADO.NET with various LINQ providers
* Bind data directly to Windows Forms and Web Forms to drive information to users
* Manage disconnected or standalone data and information
* Go beyond the core functionality of ADO.NET to manipulate data in more advanced ways

 Your step by step digital content includes:

* Practice exercises
* Fully searchable online edition of this book -- with unlimited access on the Web

CONTENTS:

Acknowledgments; Introduction; Who Is This Book For?; Organization of This Book; Conventions and Features in This Book; System Requirements; Code Samples; Errata and Book Support; We Want to Hear from You; Stay in Touch; Part I: Getting to Know ADO.NET; Chapter 1: Introducing ADO.NET 4; 1.1 What Is ADO.NET?; 1.2 Why ADO.NET?; 1.3 Major Components of ADO.NET; 1.4 Extensions to ADO.NET; 1.5 Connecting to External Data; 1.6 Summary; 1.7 Chapter 1 Quick Reference; Chapter 2: Building Tables of Data; 2.1 Implementing Tables; 2.2 Adding Data Columns; 2.3 Dataset Designer; 2.4 Summary; 2.5 Chapter 2 Quick Reference; Chapter 3: Storing Data in Memory; 3.1 Adding Data; 3.2 Examining and Changing Data; 3.3 Removing Data; 3.4 Batch Processing; 3.5 Validating Changes; 3.6 Summary; 3.7 Chapter 3 Quick Reference; Chapter 4: Accessing the Right Data Values; 4.1 Querying and Sorting Data; 4.2 Using Expression Columns; 4.3 Summary; 4.4 Chapter 4 Quick Reference; Chapter 5: Bringing Related Data Together; 5.1 Collecting Tables into Sets; 5.2 Establishing Relationships Between Tables; 5.3 Defining Table Constraints; 5.4 Summary; 5.5 Chapter 5 Quick Reference; Chapter 6: Turning Data into Information; 6.1 Aggregating Data; 6.2 Setting Up Indexed Views; 6.3 Summary; 6.4 Chapter 6 Quick Reference; Chapter 7: Saving and Restoring Data; 7.1 Serializing DataSet and DataTable Objects; 7.2 Guiding XML Generation; 7.3 Summary; 7.4 Chapter 7 Quick Reference; Part II: Connecting to External Data Sources; Chapter 8: Establishing External Connections; 8.1 Using Connection Strings; 8.2 Understanding Data Providers; 8.3 Connecting to SQL Server via a Data Provider; 8.4 Summary; 8.5 Chapter 8 Quick Reference; Chapter 9: Querying Databases; 9.1 Processing SQL Queries; 9.2 Returning Query Results; 9.3 Summary; 9.4 Chapter 9 Quick Reference; Chapter 10: Adding Standards to Queries; 10.1 Developing Parameterized Queries; 10.2 Using Parameters in Stored Procedures; 10.3 Summary; 10.4 Chapter 10 Quick Reference; Chapter 11: Making External Data Available Locally; 11.1 Understanding Data Adapters; 11.2 Moving Data from Source to Memory; 11.3 Moving Data from Memory to Source; 11.4 Table and Column Mapping; 11.5 Summary; 11.6 Chapter 11 Quick Reference; Chapter 12: Guaranteeing Data Integrity; 12.1 Transactions and Concurrency; 12.2 Using Local Transactions; 12.3 Using Distributed Transactions; 12.4 Summary; 12.5 Chapter 12 Quick Reference; Part III: Entity Framework; Chapter 13: Introducing the Entity Framework; 13.1 Understanding the Entity Framework; 13.2 Understanding the Entity Framework’s Layers; 13.3 Using the Entity Framework; 13.4 Summary; 13.5 Chapter 13 Quick Reference; Chapter 14: Visualizing Data Models; 14.1 Designing an Entity Framework Model; 14.2 Managing the Object Layer; 14.3 Summary; 14.4 Chapter 14 Quick Reference; Chapter 15: Querying Data in the Framework; 15.1 Getting to Know Entity SQL; 15.2 Running Entity SQL Queries; 15.3 Summary; 15.4 Chapter 15 Quick Reference; Chapter 16: Understanding Entities Through Objects; 16.1 Managing Entity Data Through Objects; 16.2 Using Query Builder Methods; 16.3 Summary; 16.4 Chapter 16 Quick Reference; Part IV: LINQ; Chapter 17: Introducing LINQ; 17.1 Getting to Know LINQ; 17.2 Using LINQ with .NET Objects; 17.3 Summary; 17.4 Chapter 17 Quick Reference; Chapter 18: Using LINQ to DataSet; 18.1 Understanding the LINQ to DataSet Provider; 18.2 Writing Queries with LINQ to DataSet; 18.3 Summary; 18.4 Chapter 18 Quick Reference; Chapter 19: Using LINQ to Entities; 19.1 Understanding the LINQ to Entities Provider; 19.2 Writing Queries with LINQ to Entities; 19.3 Summary; 19.4 Chapter 19 Quick Reference; Chapter 20: Using LINQ to SQL; 20.1 Understanding the LINQ to SQL Provider; 20.2 Using the Object Relational Designer; 20.3 Using Custom Database Functions in Queries; 20.4 Summary; 20.5 Chapter 20 Quick Reference; Part V: Presenting Data to the World; Chapter 21: Binding Data with ADO.NET; 21.1 Binding Data in Windows Forms; 21.2 Binding Data in WPF; 21.3 Binding Data in ASP.NET; 21.4 Summary; 21.5 Chapter 21 Quick Reference; Chapter 22: Providing RESTful Services with WCF Data Services; 22.1 Getting to Know the Service Layers; 22.2 Setting Up a Data Service; 22.3 Accessing a Data Service using REST; 22.4 Summary; 22.5 Chapter 22 Quick Reference;