SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

.NET Training

Our instructor is very knowledgeable of the subject. I like that we are able to ask very specific questions at any time during the course and get a complete and accurate answer.
Comment from FacilicorpNB

1. Title

  • Professional Database Programming for .NET: ADO .NET, NHibernate and LINQ for SQL (NFDBP, 4 days)
    View PDF

2. Course Pre-requisites

  • Extensive experience in Object Oriented Programming using either C# or VB .NET

3. Target Audience

  • Experienced .NET Developpers

4. Dates and Pricing

2 People for Guaranteed Live or Virtual Delivery $2,775.00 per person

5. Outline

Module 1: ADO .NET Connected Data

Topic 1: ADO .NET Overview

Topic 2: Connections

Topic 3: Connected Data: SQL Statements

Topic 4: Connected Data: Stored Procedures

Topic 5: Using Transactions

Module 2: ADO.NET: Disconnected Data

Topic 1: Using the DataSet Class

Topic 2: Change Management

Topic 3: Constraints and Relations

Topic 4: Updating the Database

Topic 5: Data Binding

Topic 6: XML Integration

Module 3: LINQ for SQL

Topic 1: Introducing LINQ for SQL

Topic 2: About ORM with LINQ

Topic 3: Creating the Context

Topic 4: LINQ Basic Syntax

Topic 5: LINQ Advanced Syntax

Topic 6: LINQ and Inheritance

Module 4: Creating a Data Access Layer

Topic 1: Creating a Generic Connection

Topic 2: Creating a Generic Command

Topic 3: Creating a Generic DataAdapter

Topic 4: Creating a Generic CommandBuilder

Topic 5: Loading a DataSet

Module 5: Building the User Interface

Topic 1: A Reminder about MVC

Topic 2: About Data Binding

Topic 3: Data Access in a Web Service

Topic 4: Data Access in a Windows Based Connected Client

Topic 5: Data Access in a Windows Based Disconnected Client

Topic 6: Data Access in a Web Application

Topic 7: Ensuring Flexible Application Configuration

Module 6: Microsoft Enterprise Library (Mel)

Topic 1: Using Microsoft Enterprise Library

Topic 2: Using Microsoft Application Blocks

Topic 3: Data Access Application Block

Topic 4: Exception Handling Block

Topic 5: Logging Application Block

Topic 6: Logging Exceptions

Topic 7: Validation Block

Module 7: NHibernate Basics

Topic 1: Overview

Topic 2: The Problem with Hand-Coded Sql

Topic 3: About ORM with NHibernate

Topic 4: NHibernate Namespaces

Topic 5: NHibernate Interfaces

Topic 6: The ISessionFactory

Topic 7: The Session Instances

Topic 8: Identity

Topic 9: NHibernate Application Configuration

Module 8: Object Mapping

Topic 1: Overview

Topic 2: The Domain Model

Topic 3: Mapping Basics

Topic 4: Mapping Objects

Topic 5: Dealing with Identity

Topic 6: Mapping Types

Topic 7: Mapping: Value Types and Entity Types

Topic 8: Mapping Class Hierarchies

Topic 9: Mapping Associations

Topic 10: Mapping Collections

Topic 11: Mapping and Polymorphism

Module 9: Application Deployment

Topic 1: Public versus Private DLLs

Topic 2: Deploying Web Applications

Topic 3: Deploying Windows Applications

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette