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

.NET Training

Course has been tailored to our needs. We are learning what we need for everyday work.
Comment from Giant Tiger

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