Any idea on when this is likely to come? It was mentioned in November 2022
It would be really create to use other DB’s including PostgresSQL, which I believe replacing npoco with EF would facilitate this.
It would be useful for non-x86 based systems too, that can’t natively run SQL.
Think it’s an ongoing process to move our queries over to EF, but no solid date set for that yet, it’s also not on the roadmap currently:
Ps. I edited your posts lightly, if you put a link on a new line, you get a cool card like above.
Thanks Seb, I did wonder if it was still on the cards. I know it’s considerable work.
Thanks for your reply.
At least Entity framework is included in Umbraco since 12(.4?). And all my custom database stuffs are done with Entity Framework, so that works fine 
To be honest, I thought they were already done phasing out NPoco, but I guess I was wrong…
I think requirement to use MSSQL (except sqlite) is holding Umbraco to grow as real replacement for every other CMS even Wordpress. When people realize that they can use Umbraco on almost every cheap VPS with 2GB RAM then popularity might explode. I have some docker installations with MSSQL express but it’s always not ideal. Many times I just decided to use SQLite even on production, because it’s easier.
Het @sebastiaan, How far along is this process, and is there anything the community can do to help? Is there a list of queries which need ported over?
As noted above, it is not on the roadmap, so it’s not far along. Unfortunately it is not possible to help in this case, it’s a bigger project that first needs to be scoped out by HQ before we can move further on it.
So, don’t hold your breath, it’s going to take a while 
Thanks Seb… again, I’m pretty sure the community would help if HQ needed support to get something moving/over-the-line.
I think being agnostic and open, like Umbraco is becoming with .net core etc, this would be definitely a great move, but appreciate it’s a large one.
This is probably true. We use and enjoy Umbraco despite MSSQL, not because of it.
Coming from a PHP background and enjoying easy setups, MSSQL for me has been the antithesis of simple database management. Onboarding new developers to the stack begins with apologizing for the complexity it brings.
Microsoft has sunset Azure SQL Edge, ARM64 support has been pulled quite some time ago.
Official Umbraco documentation explains custom table creation with EF for your own plugins.
How long until Umbraco will finally put EF (and database-agnostic storage) as a top priority? Or at least making it database-agnostic, since nPoco has multiple database providers.
The problem with the support for only MSSQL is that it is not FOSS, and Sqlite doesn’t really count since it performs so badly, plus it is not recommended to be used in production environments anyway.