.NET Training: ADO .NET, NHibernate & LINQ for SQL


Course Delivery

Live Instructor-Led Training

Course Description

The course ADO .NET, NHibernate & LINQ for SQL (.NET Training) provides participants with a wealth of knowledge in the area of .NET database development. The course begins with a look at the System.Data namespace and its many classes. You learn to use connection & command classes to execute SQL statements or to run stored procedures. The training covers the ADO .NET Entity Framework and LINQ for SQL. Other viable .NET ORM solution are also discussed including MEL & NHibernate.

Course Dates and Pricing


Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00

Course Outline

ADO .NET Connected Data

ADO .NET Overview
Connections
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

LINQ for SQL

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

Overview
The Problem with Hand-Coded Sql
About ORM with NHibernate
NHibernate Namespaces
NHibernate Interfaces
The ISessionFactory
The Session Instances
Identity
NHibernate Application Configuration

Object Mapping

Overview
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

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related .NET Training

.NET Training: ASP .NET MVC & Entity Framework Development

The course ASP .NET MVC & Entity Framework Development (.NET Training) teaches you how to design & implement an ASP .NET MVC application. You will learn how to code ASP .NET MVC models, views, & controllers in using the ASP .NET MVC design pattern. The course discusses custom controllers, globalization, state management, data access layers, styles, custom controls & more. This course can be delivered using the full .NET framework or .NET Core. Training course titled .NET Training: ASP .NET MVC & Entity Framework Development that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00

.NET Training: Creating Secure .NET Applications

The ability to build secure code which is resistant to hacker attacks is a key skills for the modern programmer. As applications become a more an more important part of our professional lives, their security vulnerabilities become more and more of a liability. The course Creating Secure .NET Applications (.NET Training) takes programmers on a complete tour of the various security concerns in a .NET application. The discussion includes threats & vulnerabilities, encryption and message digests, .NET code access security, and .NET role based security to name a few. The course concludes with a detailed study of symmetric and asymmetric encryption techniques as well as common hacks and security vulnerabilities such as SQL injection, XSS scripting, session hijacking & more. Training course titled .NET Training: Creating Secure .NET Applications that will allow you to hone your professional skills.

Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00

.NET Training: Object Oriented Programming with C# .NET

The course Object Oriented Programming with C# .NET (.NET Training) explores C# programming using Visual Studio .NET. The training includes the basics of C# .NET as they apply to object oriented programming. The course covers .NET classes, methods, properties & events. Inheritance, polymorphism, collections, abstract classes, interfaces, file IO & generics are also included. The course concludes with a discussion on database access & user interface implementation with C# .NET. Training course titled .NET Training: Object Oriented Programming with C# .NET that will allow you to hone your professional skills.

Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00

.NET Training: Advanced .NET Debugging & Troubleshooting

The course Advanced .NET Debugging & Troubleshooting (.NET Training) explores .NET development from architecture to implementation. The training covers everything from the internal architecture of the .NET CLR to .NET performance tuning. Inheritance, polymorphism, data structures, algorithms & multi-threading are also discussed. The course concludes with an overview of refactoring techniques and of the use and design of design patterns in .NET. Training course titled .NET Training: Advanced .NET Debugging & Troubleshooting that will allow you to hone your professional skills.

Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00

.NET Training: ASP .NET MVC Core and EF Core

The course ASP.NET MVC and Entity Framework Core studies every aspect of an ASP .MVC Core based web application and API. Starting the Design Pattern, the training discusses the use of Models, ViewModels, Views and Controllers using the pluggable Core architecture. Participants are trained in the development of EF Data Models and explore the use of the ViewModel to Model to Controller relationship in implementing enterprise web applications and APIs. Inversion of Control, logging, validation, exception handling and configuration and deployment are also discussed. Training course titled .NET Training: ASP .NET MVC Core and EF Core that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00

.NET Training: Building Object Oriented Applications - VB.NET

The course Building Object Oriented Applications - VB.NET (.NET Training) explores VB .NET programming using Visual Studio .NET. The training includes the basics of VB.Net as they apply to object oriented programming. The course covers .NET classes, methods, properties & events. Inheritance, polymorphism, collections, abstract classes, interfaces, file IO & generics are also included. The course concludes with a discussion on database access & user interface implementation. Training course titled .NET Training: Building Object Oriented Applications - VB.NET that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00

.NET Training: Converting VB Applications to VB .NET

The course Converting VB Applications to VB .NET (.NET Training) covers every aspect of the migration process from a previous version of VB to a .NET v4 application. We begin with an overview of the major functional differences between traditional VB applications and .NET v4 applications. Included in the discussion are all the basic code elements together with a comprehensive exploration of refactoring as an art and a science. The course presents fixes for the major code smells and discusses the essential concepts of class hierarchies and polymorphism. Having mastered the basic tools of migration, our attention shifts to the migration considerations associated with the use of .NET Entity Models, ASP .NET MVC and WCF. The course concludes with a discussion of the major differences in the areas of configuration and deployment. Training course titled .NET Training: Converting VB Applications to VB .NET that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00

.NET Training: Creating Windows Applications

The course Creating Windows Applications (.NET Training) is a detailed exploration of .NET Windows forms. The training includes Visual Studio .NET, architecture considerations for Windows Forms & the use of Windows .NET controls. Concepts such as data validation & user navigation, globalization, ADO .NET database access, multi-threaded programming and messaging are discussed in the course. This course is all about developing Windows Forms based applications with Visual Studio .NET Training course titled .NET Training: Creating Windows Applications that will allow you to hone your professional skills.

Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00

.NET Training: CSLA .NET for Enterprise Software Development

The course CSLA .NET for Enterprise Software Development (.NET Training) covers CSLA development in an enterprise environment. The training discusses everything from the basic usage of the BusinessBase class to the use of advanced data access and validation techniques. If you need to build corporate web applications with CSLA .NET, this is the course for you. Please note that this course can be delivered using either versions 3.8 or 4.5 of the CSLA .NET framework and the exercises can be built using either VB .NET or C#. Training course titled .NET Training: CSLA .NET for Enterprise Software Development that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00

.NET Training: Design Patterns & Refactoring

Design Patterns were originally proposed for the C++ community by the famous gang of Four (Booch, Jacobson and Rumbaugh). Design Patterns represent time tested and robust solutions to some common everyday problems. The course Design Patterns & Refactoring (.NET Training) aims to help senior .NET developers gain an understanding of how to use .NET design patterns effectively and appropriately. In using the proper creational, structural and behavioral design patterns, .NET programmers can greatly increase the maintainability, flexibility and robustness of their code. Training course titled .NET Training: Design Patterns & Refactoring that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00

.NET Training: Implementing WCF Distributed Solutions

The course Implementing WCF Distributed Solutions (.NET Training) teaches you about WCF development in .NET. The course begins with an overview of WCF basics including message types, contracts, protocols & bindings. The training includes understanding and customizing the WCF message payload, bindings and behaviors as well as implementing transactions. The importance of messaging in an organization makes this course a must for any programmer that uses WCF in their .NET applications. Training course titled .NET Training: Implementing WCF Distributed Solutions that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00

.NET Training: Implementing WF Workflow Solutiuons

The course Implementing WF Workflow Solutions (.NET Training) teaches you how to implement processes using Workflow Foundation (WF) in .NET. The training begins with an exploration of the WF runtime, workflow & the workflow lifecycle from beginning to end. The course covers workflow activities including basic, advanced & custom WF activities. The training also includes topics such as transactions, rules & policies and web services within .NET WF. Training course titled .NET Training: Implementing WF Workflow Solutiuons that will allow you to hone your professional skills.

Jan 15 - 17, 2025$3,350.00Feb 12 - 14, 2025$3,350.00Mar 12 - 14, 2025$3,350.00Apr 16 - 18, 2025$3,350.00May 14 - 16, 2025$3,350.00Jun 11 - 13, 2025$3,350.00Jul 16 - 18, 2025$3,350.00

.NET Training: Inheritance, Polymorphism & Design Patterns

The course Inheritance, Polymorphism & Design Patterns (.NET Training) begins with a thorough overview of UML design principles and of their use to implement enterprise grade .NET applications. Strong emphasis is placed on the concepts of inheritance, polymorphism and interfaces for proper application design. The training includes a detailed exploration of Business Entity Frameworks (ASP .NET MVC, MVVM, CSLA .NET, Prism, etc.), and advanced validation & configuration techniques. Training course titled .NET Training: Inheritance, Polymorphism & Design Patterns that will allow you to hone your professional skills.

Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00

.NET Training: Multilingual Web Development with ASP .NET

The course Multilingual Web Development with ASP .NET explores ASP .NET web development. The training begins with the design & implementation of ASP .NET web forms & the C# code behind page. The course covers server controls, data access & validation and user navigation and includes advanced topics such as globalization, generics, database access, state management & messaging to name a few. If you need to develop a traditional ASP .NET web application, this SETC Training Ottawa course if for you. Training course titled .NET Training: Multilingual Web Development with ASP .NET that will allow you to hone your professional skills.

Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00

.NET Training: New Technologies for Professional Developers

The course New Technologies for Professional Developers (.NET Training) provides a good general overview of modern .NET APIs for the full .NET Framework or .NET Core. The training begins with a review of Object Oriented programming with C# .NET including inheritance, polymorphism & interfaces. The course explores the development of a Data Access Layer using the ADO .NET Entity Framework & LINQ for SQL. This is followed by an exploration of the new GUI APIs including Windows Presentation Foundation (WPF) with MVVM & ASP .NET MVC. Service framework development is also studies using Windows Communication Foundation (WCF) for messaging applications & Workflow Foundation (WF) for workflow implementations. The course concludes with an exploration of ASP .NET AJAX for asynchronous web communications. Training course titled .NET Training: New Technologies for Professional Developers that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00

.NET Training: Object Oriented Programming with VB .NET

The course Object Oriented Programming with VB .NET (.NET Training) explores VB .NET programming using Visual Studio .NET. The training includes the basics of VB .NET as they apply to object oriented programming. The course covers .NET classes, methods, properties & events. Inheritance, polymorphism, collections, abstract classes, interfaces, file IO & generics are also included. The course concludes with a discussion on database access & user interface implementation with VB .NET. Training course titled .NET Training: Object Oriented Programming with VB .NET that will allow you to hone your professional skills.

Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00

.NET Training: Professional NHibernate Development

The course Professional NHibernate Development (.NET Training) teaches you to implement ORM for data access with NHibernate & .NET. The course begins with an exploration of NHibernate building blocks such as dialects, sessions, entities, identity & mapping files. The training includes the details of mapping files, persistence, caching, transactions & HQL. The course concludes with an exploration of the various tools and utilities that are commonly used in the context of an NHibernate based .NET application. Training course titled .NET Training: Professional NHibernate Development that will allow you to hone your professional skills.

Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00

.NET Training: Professional XML Programming

The course Professional XML Programming (.NET Training) covers every aspect of XML development in .NET. Starting with XML basics such as well-formedness and validity, the training explores DTDs, schemas & XSL stylesheets. The course also covers LINQ for XML, web services, WCF & ASP .NET AJAX. Training course titled .NET Training: Professional XML Programming that will allow you to hone your professional skills.

Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00

.NET Training: The Complete .NET Development Course

The course The Complete .NET Development Course (.NET Training) is an exploration of modern development with C# & .NET (Core or Framework). The course begins with a discussion on .NET fundamentals including data types, namespaces, classes, inheritance, polymorphism, abstract classes, constructors & destructors. This is followed by an exploration of key .NET concepts such as collections, generics, files & streams and multi-threaded programming. The course concludes with a look at web application development with ASP .NET & database development with ADO .NET. Training course titled .NET Training: The Complete .NET Development Course that will allow you to hone your professional skills.

Jan 20 - 28, 2025$6,600.00Feb 17 - 25, 2025$6,600.00Mar 17 - 25, 2025$6,600.00Apr 21 - 29, 2025$6,600.00May 19 - 27, 2025$6,600.00Jun 16 - 24, 2025$6,600.00Jul 21 - 29, 2025$6,600.00

.NET Training: WPF with MVVM for Exnterprise Development

The course WPF with MVVM for Enterprise Development (.NET Training) explores building .NET applications with WPF & the MVVM design pattern. The training includes a general introduction to MVVM followed by a detailed exploration of Models, Views & View Models in the context of an tiered enterprise application. The course covers a comparison of MVVM with MVC, WPF basics, custom controls, event handling & routing, data validation, database connectivity, globalization & more. Training course titled .NET Training: WPF with MVVM for Exnterprise Development that will allow you to hone your professional skills.

Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00

.NET Training: WPF, WCF, ADO .NET Entity Model, MEL & Unity

The course WPF, WCF, ADO .NET Entity Model, MEL & Unity (.NET Training) covers the development of MVVM based WPF applications that use MEL, the Unity Application Block and the Prism Library. The training includes the ADO .NET Entity Framework, LINQ for SQL & XML and WCF. If you want to build enterprise Windows applications using C#, this is the .NET course for you. Training course titled .NET Training: WPF, WCF, ADO .NET Entity Model, MEL & Unity that will allow you to hone your professional skills.

Jan 13 - 22, 2025$6,600.00Feb 10 - 19, 2025$6,600.00Mar 10 - 19, 2025$6,600.00Apr 14 - 23, 2025$6,600.00May 12 - 21, 2025$6,600.00Jun 9 - 18, 2025$6,600.00Jul 14 - 23, 2025$6,600.00