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® 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
Getting to Know ADO.NET
Chapter 1 Introducing ADO.NET 4
What Is ADO.NET?
Why ADO.NET?
Major Components of ADO.NET
Extensions to ADO.NET
Connecting to External Data
Summary
Chapter 1 Quick Reference
Chapter 2 Building Tables of Data
Implementing Tables
Adding Data Columns
Dataset Designer
Summary
Chapter 2 Quick Reference
Chapter 3 Storing Data in Memory
Adding Data
Examining and Changing Data
Removing Data
Batch Processing
Validating Changes
Summary
Chapter 3 Quick Reference
Chapter 4 Accessing the Right Data Values
Querying and Sorting Data
Using Expression Columns
Summary
Chapter 4 Quick Reference
Chapter 5 Bringing Related Data Together
Collecting Tables into Sets
Establishing Relationships Between Tables
Defining Table Constraints
Summary
Chapter 5 Quick Reference
Chapter 6 Turning Data into Information
Aggregating Data
Setting Up Indexed Views
Summary
Chapter 6 Quick Reference
Chapter 7 Saving and Restoring Data
Serializing DataSet and DataTable Objects
Guiding XML Generation
Summary
Chapter 7 Quick Reference
Connecting to External Data Sources
Chapter 8 Establishing External Connections
Using Connection Strings
Understanding Data Providers
Connecting to SQL Server via a Data Provider
Summary
Chapter 8 Quick Reference
Chapter 9 Querying Databases
Processing SQL Queries
Returning Query Results
Summary
Chapter 9 Quick Reference
Chapter 10 Adding Standards to Queries
Developing Parameterized Queries
Using Parameters in Stored Procedures
Summary
Chapter 10 Quick Reference
Chapter 11 Making External Data Available Locally
Understanding Data Adapters
Moving Data from Source to Memory
Moving Data from Memory to Source
Table and Column Mapping
Summary
Chapter 11 Quick Reference
Chapter 12 Guaranteeing Data Integrity
Transactions and Concurrency
Using Local Transactions
Using Distributed Transactions
Summary
Chapter 12 Quick Reference
Entity Framework
Chapter 13 Introducing the Entity Framework
Understanding the Entity Framework
Understanding the Entity Framework’s Layers
Using the Entity Framework
Summary
Chapter 13 Quick Reference
Chapter 14 Visualizing Data Models
Designing an Entity Framework Model
Managing the Object Layer
Summary
Chapter 14 Quick Reference
Chapter 15 Querying Data in the Framework
Getting to Know Entity SQL
Running Entity SQL Queries
Summary
Chapter 15 Quick Reference
Chapter 16 Understanding Entities Through Objects
Managing Entity Data Through Objects
Using Query Builder Methods
Summary
Chapter 16 Quick Reference
LINQ
Chapter 17 Introducing LINQ
Getting to Know LINQ
Using LINQ with .NET Objects
Summary
Chapter 17 Quick Reference
Chapter 18 Using LINQ to DataSet
Understanding the LINQ to DataSet Provider
Writing Queries with LINQ to DataSet
Summary
Chapter 18 Quick Reference
Chapter 19 Using LINQ to Entities
Understanding the LINQ to Entities Provider
Writing Queries with LINQ to Entities
Summary
Chapter 19 Quick Reference
Chapter 20 Using LINQ to SQL
Understanding the LINQ to SQL Provider
Using the Object Relational Designer
Using Custom Database Functions in Queries
Summary
Chapter 20 Quick Reference
Presenting Data to the World
Chapter 21 Binding Data with ADO.NET
Binding Data in Windows Forms
Binding Data in WPF
Binding Data in ASP.NET
Summary
Chapter 21 Quick Reference
Chapter 22 Providing RESTful Services with WCF Data Services
Tim Patrick is an author and software architect with over 25 years of experience in software development and technical writing. He has written six books and several articles on programming and other topics. In 2007, Microsoft awarded him with its Most Valuable Professional (MVP) award in recognition of the benefits his writings bring to Visual Basic and .NET programmers.
