[Question/request] EFCore 7 and 8 support?

[Kritner]

Glad to see a release version of the package!

The issue

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]

bump? 😅

[stefandevo]

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]

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

[okramarenko]

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.

[stefandevo]

@okramarenko do you have any idea when some updates can be done; in a couple of months EF 8 will be released....