Entity Framework 6.1, (Part 5 of 6): SQL Server Features

In this course, you’ll learn about a few of Entity Framework’s more recent additions to support SQL Server features. You’ll start with a look at Entity Framework’s support for hierarchyID or, rather, it’s missing support. Then you’ll jump into one of the best new features in Entity Framework in a long time, that would be enums, which you can use to protect the integrity of your data. Next you’ll explore Entity Framework’s support for spatial data, which support location-aware applications and data. You’ll wrap up the course with a look at table-valued functions and their support in Entity Framework.

Lesson 1:

• The HierarchyID Data Type
• Old Ways of Doing Hierarchies
• HierarchyID Data Type
• Indexing a Hierarchy
• HierarchyID Support
• Demo: Setup
• Demo: Install Entity Framework
• Demo: Entity Data Model
• Demo: Database Model
• Demo: AdventureWorks.

Lesson 2:

• Enum Support
• Demo: Add Enum Type
• Demo: Add Enum Type Cont
• Demo: Use Enum
• Demo: Context Object
• Demo: Create Person
• Demo: Create View
• Demo: Index.

Lesson 3:

• Introduction to Spatial Data
• Spatial Data Types
• Entity Framework Spatial Data
• Demo: Spatial Data
• Demo: Address Proximity
• Demo: View
• Demo: Troubleshooting.

Lesson 4:

• Table-Valued Functions (TVFs)
• Demo: Table-Valued Functions
• Demo: Controller
• Demo: Add View
• Demo: View Cont.