ADO .NET Course 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
» Acme Computer Case Study

ADO.NET Connections

» .NET Data Providers
» IDbConnection
» Connection Classes
» Connection Strings
» Connection Pooling
» Connection Events
» Error Handling

ADO.NET Connections
(Web offering only)



» 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
(Not covered in the Windows and Web offerings)



» 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
(Not covered in the Web offering)



» Data Binding in Windows Forms
» Simple Data Binding
» Complex Data Binding
» DataGrid Binding
» DataView
» Filtering 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

Below you can find city wise ADO .NET Institutes

ADO .NET training institutes in India
ADO .NET training institutes in Chennai
ADO .NET training institutes in Bangalore
ADO .NET training institutes in Mumbai
ADO .NET training institutes in Pune
ADO .NET training institutes in Delhi-NCR