Speak to our team now  0118 324 3000

Microsoft ADO.NET for C# Developers

  • Duration: 3 Days

Course Information

Overview

ADO.NET for C# Developers provides a thorough, detailed and structured walkthrough of ADO.NET concepts. This course is useful for .NET developers or architects developing database applications.

Crafts

C#

Prerequisites

Experience with developing C#.NET applications.


Course Outline

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

Whats included in this course?

  • image
    Course Manual
  • image
    Experienced Trainers
  • image
    Certificate of Attendance
  • image
    Unlimited Post Course Support

If you need something more custom, please get in touch with our team.

Request a Quote

Testimonials

  • I thoroughly enjoyed this course but do feel that the duration should be extended in order to allow more time to cover all of the topics. Noel was a fantastic trainer, happy to answer any questions and very good at explaining how to do something, thank you.

    image
    Laura Chesters

    HSBC