India: +91 90300 10123

Whatsapp:+1 516 8586 242

India: +91 40 6050 1418

USA: +1 909 233 6006

UK: +44 (0)203 371 0077

Ado Dot Net C# 2010 Online Training

ado.net c# Course Content

ADO.NET Introduction
  • Microsoft Data Access Technologies
  • From ADO to ADO.NET
  • ADO.NET Architecture
  • Namespaces and Classes
  • Interfaces
  • DataSets & Disconnected Access
  • First ADO.NET Programs
  • Acme Computer Case Study
ADO.NET Connections
  • NET Data Providers
  • IDb Connection
  • Connection Classes
  • Connection Strings
  • Connection Pooling
  • Connection Events
  • Error Handling
ADO.NET Commands
  • IDb Command
  • Command Objects
  • Creating Commands
  • Executing Commands
  • Parameterized Queries
  • Command Types
  • Using Stored Procedures
  • Batch Queries
DataReaders & Connected Access
  • DataReaders
  • IDataReader
  • IDataRecord
  • Type-Safe Accessors
  • Null Columns
  • Execute Reader Options
  • Multiple Result Sets
  • Obtaining Schema Information

 

Data Sets and Disconnected Access
  • Data Set
  • Data  Adapter
  • Command Objects
  • DataTable
  • DataColumn
  • DataRow
  • Row States and Versions
  • Accept or Reject Changes
  • DataTable Events
  • Database Updation  from a DataSet
  • Command Builders
More About DataSets
  • Filtering DataTables
  • Multiple Table DataSets
  • Schema
  • Constraints
  • Relations
  • Navigating DataSet
  • Data Mapping
  • Creating a DataSet Programmatically
XML & ADO.NET
  • Strong Coupling Between ADO.NET and XML
  • XML Rendering from a DataSet
  • Controlling XML Output
  • XML Reading into a DataSet
  • XML Schema & DataSets
  • Typed DataSets
  • Table Adapters
  • Synchronizing DataSets and XML
  • XML Serializatio
Concurrency and Transactions
  • DataSets & Concurrency
  • Optimistic Concurrency
  • Pessimistic Concurrency
  • Handling Concurrency Violations
  • ADO.NET Transactions
  • Database Transactions
Additional Features
  • Asynchronous Database Operations
  • Multiple Active Result Sets
  • Bulk Copy
LINQ & Entity Framework
  • Language Integrated Query (LINQ)
  • Bridging Objects and Data
  • Using Object Relational Designer
  • Filtering, Ordering & Aggregation
  • Inserts, Deletes and Updates
  • LINQ to SQL
  • LINQ to DataSet
  • ADO.NET Entity Framework
  • LINQ to Entities