Introduction to Entity Framework Core

Entity Framework Core also known as EF Core is the latest version of Microsoft’s Entity Framework. It is an Object/Relational Mapping (O/RM) framework, an enhanced version of ADO.NET, that automates data storage and retrieval from the database. EF Core is very powerful and also very easy to learn and use in your projects.

This tutorial is a part of Entity Framework Core series.

• 1. Introduction to Entity Framework Core
• 2. Installation of Entity Framework Core
• 3. Database-First approach in Entity Framework Core
• 4. DbContext Class in Entity Framework Core
• 5. Code-First Approach in Entity Framework Core
• 6. Migrations in Entity Framework Core
• 7. Insert Records in Entity Framework Core
• 8. Read Records in Entity Framework Core
• 9. Update Records in Entity Framework Core
• 10. Delete Records in Entity Framework Core
• 11. Conventions in Entity Framework Core
• 12. Configurations in Entity Framework Core
• 13. Fluent API in Entity Framework Core
• 14. Configure One-to-Many relationship using Fluent API in Entity Framework Core
• 15. Configure One-to-One relationship using Fluent API in Entity Framework Core
• 16. Configure Many-to-Many relationship using Fluent API in Entity Framework Core
• 17. Execute Raw SQL Queries using FromSqlRaw() method in Entity Framework Core
• 18. Execute SQL Stored Procedures using FromSqlRaw() & ExecuteSqlRawAsync() methods in Entity Framework Core

EF Core Supported Application Types

You can use Entity Framework Core on:

• 1. Console Applications
• 2. Windows Applications
• 3. ASP.NET Web Forms
• 4. ASP.NET MVC
• 5. ASP.NET MVC Core
• 6. WPF
• 7. Xamarin Framework.
• 8. Web API

EF Core Versions

Working on EF Core

There are 2 approaches when doing development in EF Core. These are:

• 1. Database First.
• 2. Code First.

There is very little support of Database First approach since there is no visual designer, like .edmx file, in EF Core. The EF Core mainly supports Code First approach.

Database First Approach

In Database First approach the domain & context classes are created based on the existing Database.

Code First Approach

In Code First approach the domain & context classes are created by you then EF Core created the database using these classes. The term Migration is used whenever EF Core creates or updates the Database based on the domain & context classes.

Entity Framework Core Features

Some important features of EF Core are:

• 1. DbContext & DbSet
• 2. LINQ Support
• 3. Tracking
• 4. Migrations
• 5. Batch Insert, Update and Delete operations

Supported Databases

Entity Framework Core works on many databases like:

1. SQL Server
2. MySQL
3. PostgreSQL
4. SQLite
5. SQL Compact
6. Firebird
7. Oracle
8. Db2