IT Course Outline

ADO.NET Using C#

Prerequisites : A basic knowledge of SQL and of programming the .NET Framework using C#. The student should also understand the fundamentals of XML. To get full benefit from the case studies in the course the student should be able to write simple Windows Forms applications. A working knowledge of SQL Server is also desirable.

Course Length: 3 days

Course Description

This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.

Course Topics

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 More About DataSets Filtering DataTables Multiple Table DataSets Schema Constraints Relations Navigating a DataSet DataMapping Creating a DataSet Programmatically ADO.NET Connections .NET Data Providers IDbConnection Connection Classes Connection Strings Connection Pooling Connection Events Error Handling 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 ADO.NET Commands IDbCommand Command Objects Creating Commands Executing Commands Parameterized Queries Command Types Using Stored Procedures Batch Queries Data Binding Data Binding in Windows Forms Simple Data Binding Complex Data Binding DataGrid Binding DataView Filtering and Sorting Data Binding with .NET 2.0 DataReaders and Connected Access DataReaders IDataReader IDataRecord Type-Safe Accessors Null Columns ExecuteReader Options Multiple Result Sets Obtaining Schema Information Concurrency and Transactions DataSets and Concurrency Optimistic Concurrency Pessimistic Concurrency Handling Concurrency Violations ADO.NET Transactions Database Transactions 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 New Features in ADO.NET 2.0 Asynchronous Database Operations Server Enumeration Multiple Active Result Sets Bulk Copy in ADO.NET