search

memsql / SingleStore.EntityFrameworkCore

Entity Framework Core provider for SingleStore built on top of SingleStoreConnector
MIT License
1 stars 0 forks source link

[Question/request] EFCore 7 and 8 support? #2

Open Kritner opened 2 months ago

Kritner commented 2 months ago

Glad to see a release version of the package!

The issue

image

EFCore 6 has its end of life later this year (Nov 2024), and there are certainly some perf additions and new features made available in EFCore 7 and 8 that would be great to be able to make use of.

Was curious if there is a plan and/or timeline on shipping a package that can support the newer versions of EFCore

Further technical details

Microsoft.AspNetCore.App version: 8.x

Kritner commented 3 weeks ago

bump? 😅

stefandevo commented 1 week ago

Why not team up with Pomelo directly. Integrate SingeStore as a dialect in the base repo without doing massive renames of objects? I am sure that a singlestore member can convince the maintainers to integrate Singlestore

okramarenko commented 1 week ago

hi @Kritner! we are currently working on adding EF 7 support, but, unfortunately, there's no timeline yet.

okramarenko commented 1 week ago

hi @stefandevo! unfortunately, implementing this solution is more complex than it appears (it's not only massive renames of objects). first, certain functionalities are not supported by SingleStore, and disabling them would require extensive and problematic code modifications. integrating with Pomelo would necessitate numerous hard-coded solutions for foreign keys, referential integrity, unique indexes/constraints, check constraints, savepoints, and other features.

additionally, there are significant differences between MySQL and SingleStore syntax, and syntax plays a critical role in ORM implementation. considering these challenges and the potential code complexity, we have decided to continue adapting our existing solution.