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
Share on facebook
Share on twitter
Share on linkedin
Share on email

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!