Description

Type

Course

Methodology

Online

Objectives
ADO.NET 4.0 is Microsoft’s latest API for accessing data. This course covers the core features using Visual Studio 2010, including connected and disconnected data access.
The course describes how to manage connections and execute commands, how to create and use DataSets effectively, and how to use the Entity Framework.
This course can be used as part of your preparation for Microsoft Exam 70-516: TS: Accessing Data with Microsoft .NET Framework 4
After completing this course, delegates will be able to:
Connect to a Database and Access Data
Execute Commands and Call Stored Procedures
Work with Data Using LINQ
Work with Data Using the Entity Framework
Use WCF Data Services
Audience
Developers who want to write data-access code for the .NET 4.0 platform.

About this course

Requirements

3-6 months experience of ASP.NET Web development using in C#.
Familiarity with database design is an advantage.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Reviews

Subjects

Inheritance
Access
Transactions
XML training
Microsoft .Net
Ado. Net
Ado.net
Database
SQL
Database training

Course programme

Module 1: Connecting to a Database and Reading Data

Evolution of ADO.NET
Managing connection strings
Managing connections
Reading data from a database
Connection pooling
Handling SQL exceptions

Module 2: Executing Commands

Executing query and non-query commands
Calling stored procedures
Specifying parameters
Asynchronous queries

Module 3: Transactions

Recap of ACID transactions
Managing local transactions
Managing distributed transactions

Module 4: Using ADO.NET in GUI Applications

Implementing a data access layer
Binding data to WPF user interfaces
Updating the database

Module 5: Disconnected Data Access

Populating and saving a DataSet
Adding, modifying, and deleting data in a DataSet
Using DataViews

Module 6: Creating and Using Typed DataSets

Creating a typed DataSet
Managing data in a typed DataSet
Adding code to a typed DataSet
Adding queries to a typed DataSet
Using DataSets as XML

Module 7: Getting Started with LINQ

Using LINQ with arrays, collections, and DataSets
LINQ under the hood
LINQ techniques
Performing joins

Module 8: Using LINQ to SQL

Overview of LINQ to SQL
Defining relations
Generating mapping classes
Inserting, updating, and deleting entities
Saving changes
Handling optimistic concurrency conflicts

Module 9: Creating an Entity Model Using the Entity Framework

Overview of the Entity Framework
Overview of entity data models
Defining an entity data model
Modifying an entity data model

Module 10: Working with Data Using the Entity Framework

Using LINQ to Entities
Using Entity SQL
Modifying entities
Attaching/detaching entities

Module 11: Going Further with Entity Framework Mapping

Defining relationships
Inheritance scenarios
Implementing inheritance mappings

Module 12: Entity Framework POCOs

Getting started with POCOs
POCO configuration
Working with POCO objects
Using POCO in ASP.NET MVC

Module 13: WCF Data Services

Getting started with WCF
Data Services WCF Data Services walkthrough
Additional considerations

Module 14: Developing Reliable Applications

Using performance counters
Handling exceptions
Protecting data

Module 15: Using Synchronization Services

Overview of Synchronization Services
Downloading and uploading data by using Synchronization Services

Additional information

28 hours (usually 4 days including breaks)

See related categories

Contact us

ADO.NET 4.0 Development Training Course

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

ADO.NET 4.0 Development Training Course

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.