Hacker News new | ask | show | jobs
by richman777 3591 days ago
EntityFramework? In my 5 or 6 years with .NET I've had more problems with EntityFramework than not. Most of the time it's overkill or just not optimized for the queries I could write myself. I'm a huge fan of Dapper.Net. Looks like there's initial support for core as well.
1 comments
mattmanser 3590 days ago
No offence, but you're probably using it wrong.

These days, it's really very, very good. And it's been amazing since EF4, for about 5 years now. Trying to push it too far is a mistake and can cause performance problems, but, as with all ORMs, sometimes you need to drop down to raw queries.

link
richman777 3583 days ago
Missed this comment but I don't take offense to it.

In all honesty, if you have a well designed system it's pretty good at what it does. I've used it without any issues on small personal projects and it was great at what it did. Although getting it to work with Postgres is needlessly "complicated". Not complicated per-say but not as easy as it just working with SQL Server.

What happens when you take a legacy system and move over to .Net and try to use EF on a poorly architectured data model? Chaos.

"Oh you want to search for orders that have these attributes that are stored in a bit-encoded string field that is only joined from 3 different tables?"

link