Overview

In this course, experienced developers who know the basics of data access (CRUD) in Windows client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET.

Duration

5 Days

Target Audience

This course is intended for professional .NET software developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. They will have experience implementing data access and data binding within their Web and/or Windows client applications and are interested in learning to optimize data access code in their applications by using the Entity Framework, LINQ, and ADO.NET. Members of the audience are experienced users of Microsoft Visual Studio 2008 SP1 or newer releases of the Visual Studio product. The audience has some experience using Visual Studio 2010 for either Windows client or Web application development.

Topics

Architecture and Data Access Technologies

Building Entity Data Models

Querying Entity Data

Creating, Updating, and Deleting Entity Data

Handling Multi-User Scenarios by Using Object Services

Building Optimized Solutions by Using Object Services

Customizing Entities and Building Custom Entity Classes

Using POCO Classes with the Entity Framework

Building an N-Tier Solution by Using the Entity Framework

Handling Updates in an N-Tier Solution by Using the Entity Framework

Building Occasionally Connected Solutions

Querying Data by Using WCF Data Services

Updating Data by Using WCF Data Services

Using ADO.NET

Using LINQ to SQL

A more comprehensive course outline is available in the Course Download section, to the right of this page.

MTC serves the whole of the North East region, including, Sunderland, Newcastle, Durham Teesside, Tyne and Wear, Cumbria, Northumberland, Darlington, North Yorkshire, Carlisle, Hartlepool. In addition MTC supports many clients nationally within the UK.