Anyone who's been living in .NET world has definitely heard about Entity Framework. First appeared in 2008, it's aim was to "eliminate the need for data access code". It's been 17 years now and I can tell that while the idea was great, the implementation is so-so at best and unsupportable at worst. If you have ever tried to debug a long running LINQ query you will know what I'm talking about.
But it's 2025 now, so where are we at with this?
Let's look at some typical backend tasks: data loading from a csv file, running some read, update, delete queries against the data. That pretty much covers it when it comes to a database interaction in 90% of the cases.
With the results that I see we're still very very far from EF to be remotely fast for anything other than small(ish) datasets. Indexing helps, however there's still a massive performance difference between LINQ and SQL.
I believe the whole idea behind ORMs was to expedite the development time instead of making developers learn SQL, however my observations in the field show that this backfires quite badly unless you're using it for relatively small datasets, provided indexing is in place.
