Umbraco and Entity Framework instead of nPoco

Questions
1

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.

1 Like
2

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.

1 Like
3

Thanks Seb, I did wonder if it was still on the cards. I know it’s considerable work.
Thanks for your reply.

1 Like
4

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 :slight_smile: To be honest, I thought they were already done phasing out NPoco, but I guess I was wrong…

5

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.

2 Likes
6

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?

1 Like
7

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 :sweat_smile:

1 Like
8

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.

9

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.