Learn your way! Get started

Entity Framework 5.0: What's New

with expert Don Kiely

Watch trailer

Course at a glance

Included in these subscriptions:

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

Release date 7/1/2013
Level Advanced
Runtime 1h 33m
Closed captioning Included
Transcript Included
eBooks / courseware Included
Hands-on labs Included
Sample code Included
Exams Included

Enterprise Solutions

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

Course description

In this course we’ll start out by taking a look at the high-level view of this release, looking at what versions of .NET and Visual Studio it supports, and migrating Entity Framework 4 applications. There’s a bit of a trick to doing a migration, but once you know it the process is pretty easy. Then you’ll learn about the most highly-anticipated feature in this release, its support for ENUMS. Next I’ll look at the new support for SQL Server’s spatial data types, as well as support for table-valued functions. The model designer has gotten a lot of love from Microsoft in this release, with the ability to use custom colors for entities and, my favorite, creating multiple diagrams for a single model. We’ll wrap up the course with a look at the performance enhancements provided by Entity Framework 5.


This course assumes that you are experienced with relational database design and programming concepts, and have experience with version 4.x of Entity Framework. 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.

Learning Paths

This course will help you prepare for the following certification and exam:
MCSD: Web Applications
70-487: Developing Windows Azure and Web Services

Meet the expert

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

What's New

Entity Framework (23:25)
  • Introduction (00:36)
  • Entity Framework 5 (02:09)
  • Migrating from Version 4.x (01:27)
  • Demo: Migrating Forward (03:06)
  • Demo: Target Framework (01:41)
  • Demo: Install EF5 (05:04)
  • HierarchyID Support (00:51)
  • Demo: Entity Framework (04:13)
  • Demo: New Model (02:32)
  • Code First Enhancements (01:05)
  • Summary (00:34)
Enum Support (12:04)
  • Introduction (00:36)
  • Enum Support (02:06)
  • Demo: Enums (05:41)
  • Demo: Enum Types (03:13)
  • Summary (00:26)
Spatial Data (15:11)
  • Introduction (00:53)
  • Introduction to Spatial Data (01:38)
  • Spatial Data Types (02:58)
  • Spatial Data in Entity Framework (01:06)
  • Demo: Spatial Data (04:13)
  • Demo: Spatial Data Code (04:00)
  • Summary (00:19)

Functions, Designer and Performance

Table Valued Functions (10:32)
  • Introduction (00:41)
  • Table-Valued Functions (01:24)
  • Demo: Table-Valued Functions (04:48)
  • Demo: Entities and Functions (03:15)
  • Summary (00:22)
Entity Framework Designer (22:34)
  • Introduction (00:26)
  • Entity Framework Designer (03:19)
  • Demo: DB Context Support (03:32)
  • Demo: Multiple Diagrams (04:49)
  • Demo: Diagram Details (03:11)
  • Demo: Diagram Properties (02:37)
  • Demo: Stored Procedures (03:58)
  • Summary (00:39)
Performance Enhancements (09:37)
  • Introduction (00:55)
  • Performance Enhancements (01:41)
  • Automatic Query Compilation (06:33)
  • Summary (00:27)