ADO.NET Using C# (VS 2015)

Course Number:



Course Duration:
3 Days


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 examples in the course the student should be able to write simple Windows Forms applications. A working knowledge of SQL Server is also desirable.

Course Objectives:
  • Understand the architecture and main classes of ADO.NET
  • Gain fluency in programming ADO.NET using C#
  • Gain a thorough understanding of the use of disconnected DataSets for building highly scalable applications
  • Acquire a working knowledge of the tight coupling of XML with ADO.NET
  • Learn how to use additional features in ADO.NET, including asynchronous operations, multiple active result sets, and bulk copy
  • Acquire a working knowledge of LINQ and the Entity Framework
  • Implement a realistic case study that ties together many concepts of ADO.NET in a practical demonstration
Course Outline:
  • Introduction to ADO.NET
    • Microsoft Data Access Technologies
    • From ADO to ADO.NET
    • NET Architecture
    • Namespaces and Classes
    • Interfaces
    • DataSets and Disconnected Access
    • First ADO.NET Programs
    • Acme Computer Case Study
  • NET Connections
    • .NET Data Providers
    • IDbConnection
    • Connection Classes
    • Connection Strings
    • Connection Pooling
    • Connection Events
    • Error Handling
  • 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
  • Concurrency and Transactions
    • DataSets and Concurrency
    • Optimistic Concurrency
    • Pessimistic Concurrency
    • Handling Concurrency Violations
    • NET Transactions
    • Database Transactions
  • Additional Features
    • Asynchronous Database Operations
    • Multiple Active Result Sets
    • Bulk Copy
  • LINQ and Entity Framework
    • 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
    • NET Entity Framework
    • LINQ to Entities
  • Appendix A. Acme Computer Case Study
  • Appendix B. SQL Server 2014 Express
  • Appendix C. Learning Resources

Related Posts

About Us

IT Training, Agile Ways of Working and High Impact Talent Development Strategies

Let Us Come to You!

Classes recently delivered in: Atlanta, Boston, Chicago, Columbus, Dallas, Detroit, Indianapolis, Jerusalem, London, Milan, New York, Palo Alto, Phoenix, Pittsburgh, Portland, Raleigh, San Antonio, San Diego, San Francisco, San Jose, Seattle, Springfield, Mass., St. Louis, Tampa and more!