Learn your way! Get started

Entity Framework 6.1, Part 1: Introduction

with expert Don Kiely

Watch trailer

Entity Framework 6.1, Part 1: Introduction Trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
  • Power Pack Plus

Release date Release date 7/29/2014
Level Level Advanced
Runtime Runtime 2h 21m
Platform Platform Major browsers on Windows Major browsers on Windows Major browsers on Mac OSX Major browsers on Mac OSX Mobile Devices Mobile Devices
Closed captioning Closed captioning Included
Transcript Transcript Included
eBooks / courseware eBooks / courseware Included
Hands-on labs Hands-on labs N/A
Sample code Sample code N/A
Exams Exams Included

Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

In this course you’ll learn some of the basics of object relational mapping systems and how they overcome some of the problems when working with relational data in an object based application. You’ll also see how entity objects are a big improvement over generic data objects, such as the data set and the data tables provided by ADO.NET. Then you’ll learn specifically about the Entity Framework, Microsoft’s ORM technology and why it is a compelling data access technology in the .NET development space. Big spoiler, it’s not just because Microsoft has made Entity Framework their core data access strategy. You’ll see Entity Framework in action to build a simple but powerful data access application as well as some of the APIs and tools it provides.


This course assumes that you are experienced with relational database design and programming concepts. Entity Framework is all about data access, and the course doesn’t spend any time on data fundamentals. You’ll also need a good understanding of object-oriented programming in C#, so that you know how to use the entity data objects that Entity Framework generates from your data model. You’ll also need to have a working knowledge of Language INtegrated Queries (LINQ) in C#. The course uses Entity Framework with various SQL Server databases, so you should know enough about SQL Server to know how to perform various tasks and be able to connect to a database. But you don’t need deep knowledge of SQL Server to use Entity Framework productively.

Prepare for certification

This course will help you prepare for:
70-487 Developing Windows Azure and Web Services

This course will help you earn:
MCSD: Web Applications

Meet the expert

Don Kiely Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant, specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.

Course outline


Data Access Issues (26:32)
  • Introduction (00:48)
  • Object-Relational Mapping (05:08)
  • Object/Relational Differences (00:55)
  • Data Type Differences (04:05)
  • Relationship Difference (05:58)
  • Inheritance Difference (05:24)
  • Identity/Equality Difference (02:51)
  • Handling the Differences (00:48)
  • Summary (00:31)
Object Relational Mapping (18:36)
  • Introduction (01:01)
  • Object-Relational Mapping (05:34)
  • Generic Data Objects (05:08)
  • Entity Objects (04:16)
  • Programming Against a Model (01:56)
  • Summary (00:39)
The Entity Framework (20:52)
  • Introduction (00:56)
  • The Entity Framework (03:07)
  • Compatibility with VS and .NET (03:26)
  • Entity Framework as Open Sourc (01:20)
  • Installing Entity Framework (01:06)
  • Demo: Installing EF (05:19)
  • Why Use Entity Framework? (03:27)
  • When Not to Use an ORM? (01:53)
  • Summary (00:14)

Developing,Objects and Tools

Building an Application (17:32)
  • Introduction (00:24)
  • Building an Application (02:18)
  • Demo: Building an Application (03:19)
  • Demo: Creating a new Connection (03:26)
  • Demo: Data Objects (02:10)
  • Demo: Building - the model (05:07)
  • Summary (00:46)
Entity Object Project (22:17)
  • Introduction (00:19)
  • Demo: Model Designer (04:50)
  • Demo: Properties (03:54)
  • Demo: Relationships (04:44)
  • Demo: XML View (02:58)
  • Demo: Top Level File (05:04)
  • Summary (00:25)
Using Entity Objects (12:53)
  • Introduction (00:29)
  • Using the Entity Objects (00:52)
  • Demo: Console Application (04:28)
  • Demo: Access Code (02:53)
  • Demo: Process Code (03:44)
  • Summary (00:25)
API and Tools (22:48)
  • Introduction (00:28)
  • EntityFramework APIs and Tools (05:22)
  • Entity Data Model Designer (01:51)
  • Design Methodologies (03:55)
  • Code Generation Using T4 (01:33)
  • Object Services (02:29)
  • Entity Client (03:05)
  • Entity Framework Services (03:26)
  • Summary (00:36)