> For the complete documentation index, see [llms.txt](https://dailyjournal.gitbook.io/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dailyjournal.gitbook.io/notes/orms/entity-framework.md).

# Entity Framework

a modern object-database mapper

In .NET applications, ADO.NET is an old and powerful method for accessing databases and requires a lot of coding. Simply put, all of the work is done manually. Microsoft has therefore introduced Entity Framework to automate the database technique. 

{% embed url="<https://docs.microsoft.com/en-us/ef/>" %}

|                                                                                                      Versions                                                                                                     |
| :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------: |
|                                 EF 1.0 -> EF 3.x -> EF 4.x -> EF 5.0 -> [EF 6.x](https://docs.microsoft.com/en-us/ef/ef6/) => [EF Core](https://docs.microsoft.com/en-us/ef/core/)                                |
| EF Core 1.x -> EF Core 2.x -> EF Core 3.x -> EF Core 5 -> EF Core 6 -> EF Core 7 -> EF Core 8 -> EF Core 9 -> [EF Core 10](https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-10.0/whatsnew) (Current) |

## EF Core

Entity Framework (EF) Core is a lightweight, extensible, open source and cross-platform object-relational mapper (O/RM) for .NET, which:

* Enables developers to work with a database using .NET objects.
* Eliminates the need for most of the data-access code that typically needs to be written.
* It supports LINQ queries, change tracking, updates, and schema migrations.&#x20;
* works with SQL Server/Azure SQL Database, SQLite, Azure Cosmos DB, MySQL, PostgreSQL, and many more databases through a [database provider plugin model](https://learn.microsoft.com/en-us/ef/core/providers/).

{% embed url="<https://github.com/dotnet/efcore>" %}

{% embed url="<https://www.youtube.com/playlist?list=PLdo4fOcmZ0oXCPdC3fTFA3Z79-eVH3K-s>" %}

{% embed url="<https://learn.microsoft.com/en-us/ef/efcore-and-ef6/>" %}