[IGNITE-22132] .NET: Thin 3.0: EF Core provider

• Type: Epic
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: platforms, thin client
• Labels: ignite-3
• Epic Name: .NET: Thin 3.0: EF Core provider

Language

C#

• Assignee: Pavel Tupitsyn
• Reporter: Pavel Tupitsyn
• Created: 29/Apr/24 05:29
• Updated: 30/Apr/24 12:06

Description

EF Core provider will allow using Ignite as any other DB supported by EF.
This makes adoption incredibly easy for the users - a matter of a few changed lines to switch from Postgres/MsSQL/MySQL, keeping all existing code.

But we already have a LINQ provider, what is the difference?

Think micro-ORM vs full-blown one.

Ignite LINQ provider:

• Comes in the box, very lightweight
• Can do LINQ without any setup, literally one line
• Limited DML
• No DDL

EF Core:

• Separate package
• Full-blown ORM, extremely powerful
• Familiar to any .NET developer, same API for many databases

More Info

• EF Core is the most popular ORM for .NET. Provides an abstract way of working with a database without writing any SQL by hand. Includes DDL, DML, migrations.
• Providers exist for many databases: https://learn.microsoft.com/en-us/ef/core/providers/
• Writing a provider: https://learn.microsoft.com/en-us/ef/core/providers/writing-a-provider
• Reference implementation: https://github.com/dotnet/efcore/tree/main/src/EFCore.Sqlite.Core