Home > Courses Certifications > Programming > Course 6464 synopsis

6464 C# - Visual Studio 2008: ADO.NET 3.5

Prerequisites: Before attending this course, students should have intermediate experience developing applications by using previous versions of Microsoft Visual Studio at level 200.

Duration: 2 days

Module 1: Getting Started with ADO.NET 3.5

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

Module 2: Modifying Data Using ADO.NET Commands

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

Module 3: Querying and Maintaining Data 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 4: Querying and Maintaining Data 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 5: Implementing an EDM 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 6: Building Occasionally Connected Solutions Using Sync Services

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