About this workshop
This workshop provides participants with the knowledge and skills to access and modify data by using ADO.NET 3.5.
Duration
2 days
Upon completion
Participants will be able to:
· 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.
Workshop Agenda
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
2: Modifying Data by Using ADO.NET Commands
· Inserting, Updating, and Deleting Data
· Managing Data Integrity and Concurrency
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
4: 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
5: 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
6: Building Occasionally Connected Solutions by Using Synchronization Services
· Understanding Microsoft Synchronization Services
· Downloading Data by Using Synchronization Services
· Uploading Data by Using Synchronization Services
