Entity Framework Core Tutorial

Welcome to the Entity Framework Core Tutorial or EF Core Tutorial.  We have created the step by step guide to the EF Core. This is a simple tutorial for beginners to professionals to learn the all the features & concepts of the Entity Framework Core.

Prerequisite

• C#
• Visual Studio 2017
• MS SQL Server and Querries

What is Entity Framework Core

The Microsoft Entity Framework Core or EF Core is Microsoft’s implementation of  ORM Framework.  The applications created using the EF does not work with the database directly. The application works only with the API provided by the EF for database related operations. The EF maps those operations to the database.

Table of Content

1. Getting Started

Getting Started: Create your First Entity Framework Console Application 
This Getting Started Tutorial guides you through the process of creating your first EF Core Application from scratch.

2. Connecting to Database

1. Database Connection String
2. DBContext
3. Migrations in EF Core
4. Reverse Engineer Database (Database First)

3. Configuring the Model

1. Code First Conventions in Entity Framework Core 
   Learn how to configure the models in Entity framework Core using the Conventions.
2. Data Annotations in entity framework Core 
   This tutorial explains how to use the Data Annotations to configure the database schema. The Data annotations attribute help Entity Framework Code First to apply the certain rules on entity models. The following are the list of Data Annotation attributes available in the Entity Framework Code First 
   1. Table Attribute
   2. Column Attribute
   3. Key Attribute
   4. ComplexType Attribute
   5. ConcurrencyCheck Attribute
   6. Timestamp Attribute
   7. Databasegenerated Attribute
   8. ForeignKey Attribute
   9. MaxLength Attribute
   10. StringLength Attribute
   11. NotMapped Attribute
   12. Required Attribute
   13. InverseProperty Attribute
3. Fluent API Entity Framework Core 
   Learn how to configure the models in Entity framework Core using the Fluent API
   
   1. Ignore Method
   2. HasAlternateKey

4. Configuring the Relationships

1. Relationships & Navigational Properties
2. One to One Relationships
3. One to Many Relationships
4. Many To Many Relationships