# Entity Framework Core Course Outline

### Introduction

* What is an ORM?
* What is Entity Framework Core?
* History of Entity Framework
  * EF Core vs EF 6
* Introducing the Project

### Installations

* Tools needed

### Code-First

* Creating a Model
* Adding a Migration
* Reading or Writing Data

### Existing Database (DB-First)

* Creating a Model for an Existing Database
* Scaffold-DbContext Command
* Using the DotNet CLI

#### DbContext

* Understanding the DbContext
* DbContext Methods and Properties

#### Querying Data

* Querying Basics
* Filtering Queries
* Sorting Data
* Aggregating Results

#### Tracking and Saving Data

* Tracking and Saving Workflow
* Insert, Update and Delete Simple Objects
* Updating Untracked Objects
* Tracking Multiple Objects and Bulk Support

### Migrations

* Understanding Migrations
* Design-Time Migrations Tools
* Adding a Migration
* Inspecting a Migration
* Script or Create a Database
* Removing a Migration
* Reverting a Migration
* PMC and CLI Commands

### Relationships

* Defining Many to Many Relationship
* Defining One to One Relationship

### Defining One to Many Relationship

* 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
* Modifying Related Data
* Understanding Deleting

### 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

### Data Annotations

### Fluent API

### Understanding EF Core's Database Connectivity

* EF Core Database Providers
* Transaction Support and Concurrency Handling

### EF Core Pipeline


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.peruzal.com/course-outlines/entity-framework-core-course-outline.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.