Ms.Net Visual Studio 2008 Ado.Net, Linq, Entity Framework

Module 1 Connecting to Databases and Reading Data

• What Is ADO.NET?
• The Process for Connecting to a Database and Reading Data
• What Is Connection Pooling?

Module 2: Querying and Updating Databases by Using Commands

• ADO.NET Commands
• The Process for Passing Parameters into Commands

Module 3: Performing Transactional Operations

• What Is a Transaction?
• The Process for Managing Local Transactions
• The Process for Managing Distributed Transactions
• Isolation Levels

Module 4: Performing Disconnected Operations Programmatically

• What Is the ADO.NET Disconnected Model?
• The Process for Loading and Saving Data in a DataSet
• What Are DataViews?

Module 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards

• Comparing Untyped DataSets with Typed DataSets
• What Are Table Adapters?

Module 6: Performing XML Operations on Disconnected Data

• XML Representations of DataSets
• What Are DiffGrams?
• Module 7: Reading and Writing XML Data
• The Process for Serially Reading XML Data
• The Process for Serially Writing XML Data

Module 8: Processing XML Data by Using DOM

Module 9: Getting Started with ADO.NET 3.5

• The Structure of ADO.NET 3.5
• Connecting to a Database and Retrieving Data
• Best Practices for Managing Connections and Performing Queries

Module 10: Modifying Data by Using ADO.NET Commands

• Inserting, Updating, and Deleting Data
• Managing Data Integrity and Concurrency

Module 3: Querying and Maintaining Data by Using DataSets

• Creating and Using a DataSet to Retrieve Data
• Updating a Database by Using a DataSet
• Using a DataSet in an Occasionally Connected Environment

Module 11: Querying and Maintaining Data by Using LINQ

• Querying In-Memory Data by Using LINQ Query Expressions
• Retrieving Data by Using LINQ to SQL
• Modifying Data by Using LINQ to SQL

Module 12: Implementing an Entity Model by Using the ADO.NET Entity Framework

• Creating an Entity Data Model by Using the ADO.NET Entity Framework
• Querying and Modifying Data by Using the ADO.NET Entity Framework

Module 13: Building Occasionally Connected Solutions by Using Synchronization Services

• Understanding Microsoft Synchronization Services
• Downloading Data by Using Synchronization Services
• Uploading Data by Using Synchronization Services