What you'll learn?

  • 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.

Description

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

Audience :

This course is intended for application developers who know how to create applications in Visual Studio 2005 or 2008.

Topics :

Getting Started with ADO.NET 3.5

o  The Structure of ADO.NET 3.5

o  Connecting to a Database and Retrieving Data

o  Best Practices for Managing Connections and Performing Queries

Modifying Data by Using ADO.NET Commands

o  Inserting, Updating, and Deleting Data

o  Managing Data Integrity and Concurrency

Querying and Maintaining Data by Using DataSets

o  Creating and Using a DataSet to Retrieve Data

o  Updating a Database by Using a DataSet

o  Using a DataSet in an Occasionally Connected Environment

Querying and Maintaining Data by Using LINQ

o  Querying In-Memory Data by Using LINQ Query Expressions

o  Retrieving Data by Using LINQ to SQL

o  Modifying Data by Using LINQ to SQL

Implementing an Entity Model by Using the ADO.NET Entity Framework

o  Creating an Entity Data Model by Using the ADO.NET Entity Framework

o  Querying and Modifying Data by Using the ADO.NET Entity Framework

Building Occasionally Connected Solutions by Using Synchronization Services

o  Understanding Microsoft Synchronization Services

o  Downloading Data by Using Synchronization Services

o  Uploading Data by Using Synchronization Services

Prerequisities :

Recommended Knowledge :

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

Recommended Course(s) :

Category :

  • Programming

Training Materials :

Microsoft Official Courseware (MOC)

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

This course is a credit towards •MCTS: Microsoft .NET Framework 3.5, ADO.NET Application Development •MCPD: Enterprise Application Developer 3.5