Developing Applications with Entity Framework 4.1, Part 3 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

292 Minutes

Time to complete

372 Minutes

Course Outline

Module 7

Aggregates / Grouping/ Other Options (38:51)

• Introduction (00:40)
• Aggregates (00:43)
• Demo: Aggregates (08:36)
• Other Querying Options (01:08)
• Querying w/Entity SQL (01:02)
• Demo: Entity SQL (01:47)
• Basic Entity SQL Syntax (01:42)
• VALUE Keyword (01:17)
• Demo: Parameterized Entity SQL (05:45)
• Canonical Functions (02:47)
• Entity SQL Method Syntax (01:16)
• Demo: Entity SQL Method Syntax (02:57)
• Directly Querying EntityClient (01:48)
• Demo: Querying EntityClient (06:49)
• Summary (00:27)

Updating Entities / Saving Data (24:42)

• Introduction (02:42)
• Updating Existing Entities (00:36)
• Demo: Update an Entity (06:04)
• Inserting New Entities (01:02)
• Demo: Insert New Entities (07:29)
• Deleting Entities (02:05)
• Demo: Deleting Entities (04:15)
• Summary (00:25)

Module 8

Modifying Entities in the Model Designer (03:57)

• Introduction (02:02)
• Sample AWLT Model (03:19)
• Modify Entities in the Designer (00:59)
• Organizing the Model (01:04)
• Demo: Explore/Arrange Model (08:05)
• Cleaning up the Model (00:44)
• Messy Database (05:43)
• Entities (00:40)
• Demo: Explore Entity Names (08:15)
• Entity Properties (00:42)
• Demo: Explore Entity Props (12:31)
• Navigation Properties (00:25)
• Demo: Explore Navigation Props (10:50)
• Default Values (02:37)
• Demo: Default Values (05:27)
• Summary (00:27)

Customizing Entities (25:43)

• Introduction (02:45)
• Demo: Entity Data Object Classes (03:59)
• OnChanging/OnChanged Methods (01:10)
• Demo: OnChanging/OnChanged (04:01)
• Demo: Code to Use Partial Classes (03:55)
• Demo: PropertyChangedValidation (03:18)
• Demo: View a Computed Field (05:28)
• Summary (01:03)

Module 9

Entity Framework Events (20:10)

• Introduction (00:55)
• ObjectContexts ObjectMaterialized (01:36)
• ObjectContexts SavingChanges (03:38)
• Demo: SavingChanges (04:00)
• PropertyChanging / PropertyChanged (02:17)
• AssociationChanged Event (01:42)
• Demo: AssociationChanged Event (04:59)
• Summary (00:59)

Creating Code-First Model (34:02)

• Introduction (02:26)
• Using Code-First (01:46)
• Create/Use a Code-First Model (01:36)
• Demo: Create a Code-First Model (00:23)
• Demo: Create New Project (00:59)
• Demo: Create the Model (00:37)
• Demo: Implement Classes (03:42)
• Demo: Add Navigation Properties (04:38)
• Demo: Add Context Class (03:32)
• Secret Behind the Magic (02:04)
• Use Model in an MVC 3 App (01:28)
• Demo: Create/View Customers (00:37)
• Demo: Add Controller (09:49)
• Summary (00:19)

Module 10

Create / Update the Code-First Database (35:05)

• Introduction (01:10)
• Demo: Run the Application (02:20)
• Demo: Explore the Database (05:36)
• Demo: Add Edit Support (08:37)
• Demo: Add Delete Support (07:12)
• Demo: Modify the Model (02:52)
• Changing the Model (03:56)
• Demo: Database.SetInitializer (02:51)
• Summary (00:27)

Seeding / Customizing the Data (50:19)

• Introduction (01:13)
• Demo: Add Seed Data (06:40)
• Demo: Drop/Create the Database (03:42)
• Customizing the Database (04:44)
• Common Conventions (02:50)
• Data Annotations (01:20)
• Demo: Data Annotations (10:01)
• Demo: View Schema Changes (07:32)
• DbModelBuilder API (01:19)
• Demo: DbModelBuilder API (02:34)
• Configure Properties and Entities (01:36)
• Demo: Configure Properties / Entities (05:59)
• Summary (00:44)