Professional Database Programming for .NET: ADO .NET, NHibernate and LINQ for SQL
(NFDBP, Live Instructor-Led Training, 4 days)


This SETC Certified course provides participants with a wealth of knowledge in the area of database development in a .NET environment. The course begins with a look at the System.Data namespace and its many classes, Participants learn to make DSNless connections using connection classes while they learn to execute SQL statements or run stored procedures using specific command classes. Having mastered the basic elements of ADO .NET, the course introduces participants to the LINQ for SQL paradigm for database programming as well as the ORM techniques that are associated with NHibernate. In passing, the power of the Microsoft Enterprise Library is also explored.

Dates and Pricing

Jan 16 to Jan 19, 2018$2,500/person Feb 13 to Feb 16, 2018$2,500/person Mar 13 to Mar 16, 2018$2,500/person


ADO .NET Connected Data
ADO .NET Overview
Connected Data: SQL Statements
Connected Data: Stored Procedures
Using Transactions
ADO.NET: Disconnected Data
Using the DataSet Class
Change Management
Constraints and Relations
Updating the Database
Data Binding
XML Integration
Introducing LINQ for SQL
About ORM with LINQ
Creating the Context
LINQ Basic Syntax
LINQ Advanced Syntax
LINQ and Inheritance
Creating a Data Access Layer
Creating a Generic Connection
Creating a Generic Command
Creating a Generic DataAdapter
Creating a Generic CommandBuilder
Loading a DataSet
Building the User Interface
A Reminder about MVC
About Data Binding
Data Access in a Web Service
Data Access in a Windows Based Connected Client
Data Access in a Windows Based Disconnected Client
Data Access in a Web Application
Ensuring Flexible Application Configuration
Microsoft Enterprise Library (Mel)
Using Microsoft Enterprise Library
Using Microsoft Application Blocks
Data Access Application Block
Exception Handling Block
Logging Application Block
Logging Exceptions
Validation Block
NHibernate Basics
The Problem with Hand-Coded Sql
About ORM with NHibernate
NHibernate Namespaces
NHibernate Interfaces
The ISessionFactory
The Session Instances
NHibernate Application Configuration
Object Mapping
The Domain Model
Mapping Basics
Mapping Objects
Dealing with Identity
Mapping Types
Mapping: Value Types and Entity Types
Mapping Class Hierarchies
Mapping Associations
Mapping Collections
Mapping and Polymorphism
Application Deployment
Public versus Private DLLs
Deploying Web Applications
Deploying Windows Applications