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.

Recomended Book :Entity Framework Core in Action

Table of Content

1. Getting Started

This Getting Started Tutorial guides you through the process of creating your first EF Core Application from scratch.

1. Getting Started: Create your First Entity Framework Console Application 
   

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

The Following Tutorials Explains how to Configure the Models using Convention, Data Annotations & Fluent API

1. Code First Conventions in Entity Framework Core 
2. Data Annotations in entity framework Core 
   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 
   1. Ignore Method
   2. HasAlternateKey

4. Configuring the Relationships

Learn how to Configure the Relationships in Entity Framework  by using Navigation property and making use of Conventions, Data Annotations & Fluent API

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

5. LINQ To Entities

Querying in Entity Framework Core has not changed from its predecessor Entity Framework. The LINQ To entities is now the preferred way of Querying the Entities. The Following Articles introduces you to the LINQ to Entities and shows how to Query, Find a Single Entry

1. LINQ to Entities Tutorial in Entity Framework Core
2. Querying LINQ to Entities EF Core
3. Finding the Single Entity using Find, First, FirstOrDefault, Single, SingleOrDefault in EF Core
4. Projection Queries in Entity Framework EF Core
5. Join Queries in  EF Core