EF Core is a modern object-database mapper for .NET.
It supports LINQ queries, change tracking, updates, and schema migrations. EF Core works with many databases, including SQL Database (on-premises and Azure), SQLite, MySQL, PostgreSQL, and Azure Cosmos DB. It supports other databases through a database provider plugin model.
EF Core is free and open source software.
Features include:
- Creating a model:
- Basic class mapping.
- Constructors with parameters.
- Property value conversions.
- Mapped types with no keys.
- Conventions.
- Custom conventions.
- Data annotations.
- Fluent API.
- Inheritance: Table per hierarchy.
- Inheritance: Table per type.
- Inheritance: Table per concrete class.
- Shadow state properties.
- Alternate keys.
- Many-to-many navigations.
- Many-to-many without join entity.
- Key generation: Database.
- Key generation: Client.
- Complex/owned types.
- Spatial data.
- Model format: Code.
- Create model from database: Command line.
- Global query filters.
- Table splitting.
- Database scalar function mapping.
- Database table valued function mapping.
- Field mapping.
- Nullable reference types.
- Querying data:
- LINQ queries.
- Readable generated SQL.
- GroupBy translation.
- Loading related data: Eager.
- Loading related data: Eager loading for derived types.
- Loading related data: Lazy.
- Loading related data: Explicit.
- Raw SQL queries: Entity types.
- Raw SQL queries: Keyless entity types.
- Raw SQL queries: Composing with LINQ.
- Explicitly compiled queries.
- await foreach.
- Saving data:
- Change tracking: Snapshot.
- Change tracking: Notification.
- Change tracking: Proxies.
- Accessing tracked state.
- Optimistic concurrency.
- Transactions.
- Batching of statements.
- Disconnected graph low-level APIs.
- Disconnected graph End-to-end.
- Other features:
- Migrations.
- Database creation/deletion APIs.
- Seed data.
- Connection resiliency.
- Interceptors.
- Events.
- Simple Logging.
- DBContext pooling.
Website: docs.microsoft.com/en-gb/ef
Support: GitHub Code Repository
Developer: .NET Foundation and Contributors
License: MIT License
Entity Framework Core is written in C#. Learn C# with our recommended free books and free tutorials.
| Popular series | |
|---|---|
 | The largest compilation of the best free and open source software in the universe. Each article is supplied with a legendary ratings chart helping you to make informed decisions. |
 | Hundreds of in-depth reviews offering our unbiased and expert opinion on software. We offer helpful and impartial information. |
 | The Big List of Active Linux Distros is a large compilation of actively developed Linux distributions. |
 | Replace proprietary software with open source alternatives: Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle, Atlassian, Corel, Cisco, Intuit, and SAS. |
 | Awesome Free Linux Games Tools showcases a series of tools that making gaming on Linux a more pleasurable experience. This is a new series. |
 | Machine Learning explores practical applications of machine learning and deep learning from a Linux perspective. We've written reviews of more than 40 self-hosted apps. All are free and open source. |
 | New to Linux? Read our Linux for Starters series. We start right at the basics and teach you everything you need to know to get started with Linux. |
 | Alternatives to popular CLI tools showcases essential tools that are modern replacements for core Linux utilities. |
 | Essential Linux system tools focuses on small, indispensable utilities, useful for system administrators as well as regular users. |
 | Linux utilities to maximise your productivity. Small, indispensable tools, useful for anyone running a Linux machine. |
 | Surveys popular streaming services from a Linux perspective: Amazon Music Unlimited, Myuzi, Spotify, Deezer, Tidal. |
 | Saving Money with Linux looks at how you can reduce your energy bills running Linux. |
 | Home computers became commonplace in the 1980s. Emulate home computers including the Commodore 64, Amiga, Atari ST, ZX81, Amstrad CPC, and ZX Spectrum. |
 | Now and Then examines how promising open source software fared over the years. It can be a bumpy ride. |
 | Linux at Home looks at a range of home activities where Linux can play its part, making the most of our time at home, keeping active and engaged. |
 | Linux Candy reveals the lighter side of Linux. Have some fun and escape from the daily drudgery. |
 | Getting Started with Docker helps you master Docker, a set of platform as a service products that delivers software in packages called containers. |
 | Best Free Android Apps. We showcase free Android apps that are definitely worth downloading. There's a strict eligibility criteria for inclusion in this series. |
 | These best free books accelerate your learning of every programming language. Learn a new language today! |
 | These free tutorials offer the perfect tonic to our free programming books series. |
 | Linux Around The World showcases usergroups that are relevant to Linux enthusiasts. Great ways to meet up with fellow enthusiasts. |
 | Stars and Stripes is an occasional series looking at the impact of Linux in the USA. |