This course provides students with the knowledge and skills to access and modify data by using ADO.NET 3.5.

• Describe the purpose and structure of ADO.NET 3.5.
• Explain the role of data providers in ADO.NET 3.5.
• List the technologies and techniques available for managing data with ADO.NET 3.5.
• Insert, update, and delete data by using ADO.NET Command objects.
• Implement transactions to control data integrity and concurrency.
• Define and use a DataSet for retrieving data.
• Use a DataSet to update a database.
• Use a DataSet as a local cache in an occasionally connected environment.
• Define LINQ queries for selecting data from an in-memory data structure.
• Use LINQ to SQL to query data in a database.
• Use LINQ to SQL to modify data and save changes to the database.
• Explain how to use the ADO.NET Entity Framework to map a database schema to a logical business model.
• Use the ADO.NET Entity Framework to query and manage data.
• Explain how Synchronization Services supports occasionally-connected solutions.
• Use Synchronization Services to download data from a SQL Server database.
• Use Synchronization Services to upload data to a SQL Server database.

Topics :

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

Modifying Data by Using ADO.NET Commands

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

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

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

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

Building Occasionally Connected Solutions by Using Synchronization Services

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