Course Information

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

Prerequisites

Experience with developing VB.NET applications.

Outline

  • What Is ADO.NET?
  • Why ADO.NET?
  • Major Components of ADO.NET
  • Extensions to ADO.NET
  • Connecting to External Data
  • Implementing Tables
  • Adding Data Columns
  • Dataset Designer
  • Adding Data
  • Examining and Changing Data
  • Removing Data
  • Batch Processing
  • Validating Changes
  • Querying and Sorting Data
  • Using Expression Columns
  • Collecting Tables into Sets
  • Establishing Relationships Between Tables
  • Defining Table Constraints
  • Aggregating Data
  • Setting Up Indexed Views
  • Serializing DataSet and DataTable Objects
  • Guiding XML Generation
  • Using Connection Strings
  • Understanding Data Providers
  • Connecting to SQL Server via a Data Provider
  • Processing SQL Queries
  • Returning Query Results
  • Developing Parameterized Queries
  • Using Parameters in Stored Procedures
  • Understanding Data Adapters
  • Moving Data from Source to Memory
  • Moving Data from Memory to Source
  • Table and Column Mapping
  • Transactions and Concurrency
  • Using Local Transactions
  • Using Distributed Transactions
  • Binding Data in Windows Forms
  • Binding Data in WPF
  • Binding Data in ASP.NET
  • Getting to Know the Service Layers
  • Setting Up a Data Service
  • Accessing a Data Service using REST
Dates and Prices

There are currently no public dates for this course. This course can be run as a private course either at one of our training centers or at your offices. To get pricing for this use our quote wizard to generate a customised quote or call us on 0118 324 3000 to discuss your requirements.

image
3 Days

Testimonials

  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager-Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne-Oracle