dotnet / efcore

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
https://docs.microsoft.com/ef/
MIT License
13.48k stars 3.13k forks source link

Support of graph databases for EF Core #33795

Open ohault opened 1 month ago

ohault commented 1 month ago

For AI, support of graph databases through in EF Core will become incredibly important.

I can see it side by side with MongoDB support via MongoDB Query Language (MQL).

Can you please set this request as a high priority and strategic feature on your roadmap for next year release ?

wstaelens commented 1 month ago

Duplicate of: https://github.com/dotnet/efcore/issues/30180

ohault commented 1 month ago

Duplicate of: #30180 This is not a duplicate. This ticket is not indented to be specific or limited to SQL Server.

SamMonoRT commented 1 month ago

We'll consider this during planning for EF10

roji commented 1 month ago

@ohault at this stage, we have no knowledge of what "support of graph databases" would mean independent of any specific database; the graph functionality in the different databases (e.g. SQL Server, MongoDB) seems different enough that it's far from clear what a "cross-database graph feature" or infrastructure would look like. This is why we generally track this sort of capability on a per-database basis.

In addition, note that the MongoDB EF provider is maintained by Mongo themselves, and not in this repo.

Finally, I'd be interested to know what concrete AI-related functionality relates to graph database support - more context from you (e.g. references) could help prioritize work in this area.

wstaelens commented 1 month ago

I think that by having graph database support in EF Core for SQL Server will make small graph databases more accessible in small scale projects without having to setup any cosmos db and having to pay for azure. A simple sql express might do the trick and would work like a charm. Currently there is no good "free" alternative.