Entity Framework 6.1 Coding and Architecture using C#

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

This Entity Framework 6.1 using C# course teaches students to develop the data access layer for any .net application or web API web service. This course uses Visual Studio 2013 and 2015. This course focuses on real world data access coding and architecture using codefirst and the soon to be deprecated .EDMX in Entity Framework 7. Not only will students cover EF top to bottom but they will also use Web API Services and MVC and SPA Client Apps. Hands on exercises are the key to this course.

IF YOU ARE TIRED OF ENTITY FRAMEWORK EXAMPLES THAT EMBED DATA ACCESS CODE INTO A CLIENT APP THEN THIS IS THE COURSE FOR YOU.

Training Objectives

• Understanding ORM Tools and the evolution of EF
• Code First from existing database vs EDMX from existing database
• Code First or .EDMX without an existing database
• Separation of concerns and building data access layers
• Performing CRUD operations with EF and LINQ to Entities
• Performing CRUD operations using Stored Procedures with EF
• Creating and using POCOS
• Implementing the Entity Framework with Web API
• .NET clients that use EF
• .NET clients that use EF Via Web API
• Implementing the repository pattern with EF

Prerequisites

• Real world knowledge of C#, LINQ, SQL and the .NET Framework are required.
• Javascript knowledge is preferred but not required.
   

Course Outline:

The Entity Framework

• Introduction
• The Entity Framework
• Compatibility with VS and .NET
• Entity Framework is open source
• Installing the Entity Framework
• Demo: Installing EF using different techniques
• Why use Entity Framework?
• When not to use an ORM?
• LINQ to Entities and Lambda
• Stored procedures
• Behind the Wizards
• POCOS
• CRUD operations
• Summary

Building a DAL Decisions Decisions

• Introduction
• Building DAL Projects Theory
• Building DAL Projects HEAVY Hands ON
• Connections and Connection Strings
• .edmx and its future
• Code first is the future
• HEAVY HANDS ON
• Summary

Building a DAL with .edmx

• Introduction
• Model Designer
• Properties
• Relationships
• XML View
• HEAVY HANDS ON
• Summary

Building a DAL with Code First from Existing DB

• Introduction
• Say farewell to the EDMX
• HEAVY HANDS ON
• Summary

Code First and EDMX without an Existing DB

• Introduction
• So you don’t have a database?
• So your database is designed poorly?
• HEAVY HANDS ON
• Summary

Building a DAL to be used with Web API

• Introduction
• Combining EF with WEB API?
• Now you can use BREEZE C# and Breeze JS if needed
• Rest Services and EF is the way to go
• HEAVY HANDS ON
• Summary

Understanding and Implementing the Repository Pattern

• Introduction
• Theory?
• HEAVY HANDS ON
• Summary

Peparing For Entity Framework 7

• Introduction
• A look ahead to EF version 7