Telephone: 0208 942 5724
Email: info@aspecttraining.co.uk
Open: 09:00a.m. to 17:30p.m. Monday to Friday

ADO.NET For C# Developers

Duration: 3 Days

Overview:

Aspect Training’s ADO.NET for C# Developers provides a thorough, detailed and structured walkthrough of ADO.NET concepts

Aspect Training’s ADO.NET for C# Developers is useful for .NET developers or architects developing database applications.

Prerequisites:

Experience with developing C#.NET applications

Course Topics:

Introducing ADO.NET

What Is ADO.NET?
Why ADO.NET?
Major Components of ADO.NET
Extensions to ADO.NET
Connecting to External Data

Building Tables of Data

Implementing Tables
Adding Data Columns
Dataset Designer

Storing Data in Memory

Adding Data
Examining and Changing Data
Removing Data
Batch Processing
Validating Changes

Accessing the Right Data Values

Querying and Sorting Data
Using Expression Columns

Bringing Related Data Together

Collecting Tables into Sets
Establishing Relationships Between Tables
Defining Table Constraints

Turning Data into Information

Aggregating Data
Setting Up Indexed Views

Saving and Restoring Data

Serializing DataSet and DataTable Objects
Guiding XML Generation

Establishing External Connections

Using Connection Strings
Understanding Data Providers
Connecting to SQL Server via a Data Provider

Querying Databases

Processing SQL Queries
Returning Query Results

Adding Standards to Queries

Developing Parameterized Queries
Using Parameters in Stored Procedures

Making External Data Available Locally

Understanding Data Adapters
Moving Data from Source to Memory
Moving Data from Memory to Source
Table and Column Mapping

Guaranteeing Data Integrity

Transactions and Concurrency
Using Local Transactions
Using Distributed Transactions

Binding Data with ADO.NET

Binding Data in Windows Forms
Binding Data in WPF
Binding Data in ASP.NET

Providing RESTful Services with WCF Data Services

Getting to Know the Service Layers
Setting Up a Data Service
Accessing a Data Service using REST


Click Here for printer friendly version of outline

Ring 0208 942 5724 if you require further details or would like to book a training course

Aspect Training, 20 Coombe Road, New Malden, Surrey, KT3 4QE

© 2013 Aspect Training