Entity Framework Custom Outline

Day 1: Introduction to ASP.NET Core MVC & Pages and Entity Framework Core

Morning Session

1. Introduction to ASP.NET Core MVC & Pages

   • General Information About Asp.Net Core

   • Theory on Asp.Net Core

   • Road Map (Asp.Net Web Forms to Asp.Net Core)

2. Patterns used in Asp.Net Core

   • MVC

   • Pages

   • MVC vs Pages

Afternoon Session

1. Introduction to Entity Framework Core

   • What is an ORM?

   • What is Entity Framework Core?

   • History of Entity Framework

   • EF Core vs EF 6

2. Introducing the Project

3. Installations and Tools needed

Day 2: ASP.NET Core MVC Core Project Structure & EF Core - Basics

Morning Session

1. Asp.Net Core MVC Core Project Structure

   • Model

   • View

   • Shared Folder

   • Controller

2. A Bit on Core Classes

3. Application Settings

4. Application Dependencies

Afternoon Session

1. Code-First Approach

   • Creating a Model

   • Adding a Migration

   • Reading or Writing Data

2. Existing Database (DB-First)

   • Creating a Model for an Existing Database

   • Scaffold-DbContext Command

   • Using the DotNet CLI

Day 3: Entity Framework Core - DbContext, Querying, Tracking, and Saving Data

Morning Session

1. DbContext

   • Understanding the DbContext

   • DbContext Methods and Properties

2. Querying Data

   • Querying Basics

   • Filtering Queries

   • Sorting Data

   • Aggregating Results

Afternoon Session

1. Tracking and Saving Data

   • Tracking and Saving Workflow

   • Insert, Update, and Delete Simple Objects

   • Updating Untracked Objects

   • Tracking Multiple Objects and Bulk Support

Day 4: Entity Framework Core - Migrations and Relationships

Morning Session

1. Migrations

   • Understanding Migrations

   • Design-Time Migrations Tools

   • Adding a Migration

   • Inspecting a Migration

   • Script or Create a Database

Afternoon Session

1. Removing a Migration

2. Reverting a Migration

3. PMC and CLI Commands

4. Relationships

   • Defining Many to Many Relationship

   • Defining One to One Relationship

   • Defining One to Many Relationship

Day 5: Entity Framework Core - Advanced Topics, ASP.NET Core MVC and Pages, and Mobile Application Discussion

Morning Session

1. EF Core’s Interpretation of Your Data Model

   • Interpreting One-to-Many Relationships

   • Foreign Key Properties

   • Interacting with Related Data

   • Adding Related Data

   • Eager Loading

   • Lazy Loading

2. Modifying Related Data

   • Understanding Deleting

Afternoon Session

1. Working with Views and Stored Procedures

   • Querying with Raw SQL

   • Adding StoredProcedure using Migrations

   • Running Stored Procedure Queries with Raw SQL

   • Mapping to Views

   • Querying Database Views

2. Data Annotations

3. Scaffolding New Projects in VS

4. Asp.Net Core MVC

5. Asp.Net Core Pages

6. Incorporating a Mobile Application

   • Discussing mobile application possibilities and requirements

   • Integrating mobile applications with ASP.NET Core APIs