Developing Applications with Entity Framework 4.1, Part 2 of 3

Course description

The course starts with an introduction to Entity Framework, where you will learn about data access and object-relational mapping, how the Entity Framework works and the tools it provides, and you will see how to build an entity data model. Then you will explore the entity data model in more detail, where you will learn about the model designer and the raw XML that actually defines the conceptual, storage, and mapping models. You will also learn how you can use stored procedures and functions with Entity Framework. Next you will learn about the most important ways to query data using Entity Framework objects. You are most likely to use LINQ to Entities, but other options include Entity SQL and an Entity Client API. After that, you will learn about the ways that you can modify and customize the entity data objects, using the model designer, partial classes and methods, and events. Finally, you will learn about code-first development, which we are confident is going to become the primary way to develop new Entity Framework applications.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

This course assumes you are familiar with the Entity Framework and using Visual Studio 2010.

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.

Video Runtime

202 Minutes

Time to complete

262 Minutes

Course Outline

Module 4

Model First Designs (31:00)

• Introduction (01:27)
• Event Registration (02:30)
• Demo: Create a New Model (01:45)
• Demo: Add Items to Designer (01:26)
• Demo: Add Entities (12:06)
• Demo: Add Associations (03:29)
• Demo: Create/Generate Database (02:52)
• Demo: Examine Generated Code (05:07)
• Summary (00:15)

Model Browser / XML (44:54)

• Introduction (00:54)
• Demo: Model Browser (01:44)
• Entity Data Model in the Raw (02:18)
• XML Definition Languages (01:45)
• Demo: Explore the XML Code (00:26)
• Demo: Outline the XML (01:22)
• Demo: Designer Element (01:24)
• Demo: Diagram Content (02:08)
• Demo: Runtime Content (01:11)
• Demo: Conceptual Models (01:37)
• Demo: EntityContainer (01:06)
• Demo: EntitySet/AssociationSet (02:20)
• Demo: EntityType (03:27)
• Demo: NavigationProperty (03:24)
• Demo: Association Elements (02:35)
• Demo: Storage Models (07:45)
• Demo: Mappings (03:09)
• Demo: ScalarProperty (02:06)
• Model Build Mechanics (01:24)
• MetadataArtifactProcessing (02:13)
• Summary (00:28)

Module 5

Using Stored Procedures (33:38)

• Introduction (02:25)
• Ways to Use Stored Procedures (01:18)
• Update Model from Database (02:40)
• Demo: Define Stored Procedures (02:56)
• Demo: Import into Model (04:28)
• Demo: View Function Elements (04:17)
• Change An Entity (00:48)
• Demo: Change an Entity (04:37)
• Demo: View Changed XML (01:55)
• Demo: Test Stored Procedures (05:08)
• Demo: View SQL Server Profiler (02:47)
• Summary (00:13)

Stored Procedures To Read Data (20:25)

• Introduction (01:19)
• Demo: Read Data w/Stored Procs (11:15)
• Demo: Test Reading Data (00:29)
• Return a Scalar Value (00:59)
• Demo: Return Scalar Value (05:55)
• Demo: Test Scalar Value (00:11)
• Summary (00:15)

Module 6

Querying Entity Framework (25:18)

• Introduction (00:54)
• Entity Framework Query Options (02:33)
• Framework Architecture (01:03)
• LINQPad (02:27)
• Demo: LINQPad (05:21)
• Demo: A Simple Query (07:16)
• Demo: Examine Class Diagram (05:15)
• Summary (00:25)

LINQ to Entities (47:17)

• Introduction (00:55)
• LINQ Primer (04:13)
• LINQ Query Expressions (03:20)
• LINQ Methods (02:17)
• Demo: LINQ Query Expression (01:12)
• Demo: LINQ Methods (03:01)
• Which Syntax to use (03:12)
• LINQ to Entities (00:45)
• Projections (01:07)
• Demo: Projections (14:22)
• Querying Related Data (01:40)
• Demo: Navigation References (05:10)
• Demo: Navigation Collections (05:27)
• Summary (00:30)