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

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

Updated Feb 04, 2020

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.