ADO.NET Using C# Training

ADO.NET Training Content



    Introduction to ADO.NET
  •  Microsoft Data Access Technologies
  •  From ADO to ADO.NET
  •  ADO.NET Architecture
  •  Namespaces and Classes
  •  Interfaces
  •  DataSets and Disconnected Access
  •  First ADO.NET Programs
  • ADO.NET Connections
  •  .NET Data Providers
  •  IDbConnection
  •  Connection Classes
  •  Connection Strings
  •  Connection Pooling
  •  Connection Events
  •  Error Handling
  • ADO.NET Connections
  •  Database Programs with ASP.NET
  • ADO.NET Commands
  •  IDbCommand
  •  Command Objects
  •  Creating Commands
  •  Executing Commands
  •  Parameterized Queries
  •  Command Types
  •  Using Stored Procedures
  •  Batch Queries
  • DataReaders and Connected Access
  •  DataReaders
  •  IDataReader
  •  IDataRecord
  •  Type-Safe Accessors
  •  Null Columns
  •  ExecuteReader Options
  •  Multiple Result Sets
  •  Obtaining Schema Information
  • Data Sets and Disconnected Access
  •  DataSet
  •  DataAdapter
  •  Command Objects
  •  DataTable
  •  DataColumn
  •  DataRow
  •  Row States and Versions
  •  Accept or Reject Changes
  •  DataTable Events
  •  Updating a Database from a DataSet
  •  Command Builders
  • More About DataSets
  •  Filtering DataTables
  •  Multiple Table DataSets
  •  Schema
  •  Constraints
  •  Relations
  •  Navigating a DataSet
  •  DataMapping
  •  Creating a DataSet Programmatically
  • XML and ADO.NET
  •  Strong Coupling Between ADO.NET and XML
  •  Rendering XML from a DataSet
  •  Controlling XML Output
  •  Reading XML into a DataSet
  •  XML Schema and DataSets
  •  Typed DataSets
  •  Table Adapters
  •  Synchronizing DataSets and XML
  •  XML Serialization
  • Data Binding
  •  Data Binding in Windows Forms
  •  Simple Data Binding
  •  Complex Data Binding
  •  DataGrid Binding
  •  DataView
  •  SFiltering and Sorting
  •  Data Binding with .NET
  • Concurrency and Transactions
  •  DataSets and Concurrency
  •  Optimistic Concurrency
  •  Pessimistic Concurrency
  •  Handling Concurrency Violations
  •  ADO.NET Transactions
  •  Database Transactions
  • New Features in ADO.NET
  •  Using Server Explorer in Visual Studio
  •  Asynchronous Database Operations
  •  Multiple Active Result Sets
  •  Bulk Copy in ADO.NET
  • LINQ to ADO.NET
  •  Language Integrated Query (LINQ)
  •  Bridging Objects and Data
  •  Using Object Relational Designer
  •  Filtering, Ordering and Aggregation
  •  Inserts, Deletes and Updates
  •  LINQ to SQL
  •  LINQ to Dataset