Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Anybody else regretting using Entity Framework?

Tags:

I have a project that implemented Linq To SQL, and I was pretty happy with it. For quite awhile the biggest problem was just that the designer was buggy.

Unfortunately, my project now requires multiple table inheritance, and Linq to SQL does not support it. I decided to switch to Entity Framework when I learned that it does support multiple inheritance and seems to be the direction Microsoft is heading. But now I'm starting to regret that decision.

For instance, calling Load()? WTF? If I didn't want that data, I wouldn't be asking for it! Figuring out all of Entity Framework's anal quirks is becoming a huge thorn in my side.

Anyway... is there a light at the end of the tunnel? When I'm all done, will using EF be worth while, or have I made a terrible decision?

Finally, I would like to ask: where has Microsoft been with the whole ORM thing? Rails' ActiveRecord has been working beautifully and simply for years now.

like image 210
grimus Avatar asked May 21 '09 22:05

grimus


People also ask

Why we should not use Entity Framework?

One of the biggest reasons not to use Entity Framework Core is that your application needs the fastest possible data access. Some applications do a lot of heavy data operations with very high-performance demands, but usually business applications don't have that high of a performance demand.

Is Entity Framework good to use?

Entity Framework is the best way to develop database applications. I used to develop my applications using LINQ to SQL but since Microsoft is not going to support it in future, it recommends to use Entity Framework. By the way, Entity Framework 4 in . NET 4 has much better performance than previous versions.

Is Entity Framework suitable for enterprise applications?

Yes, and you'll find a number of nice features well suited toward rapid application development.


1 Answers

You are not alone in your pain. There has been a series of posts on the ADO.NET blog discussing the enhancements that are being made to the Entity Framework in .NET 4.0. They seem to be pretty significant, but whether or not they are sufficient for your needs, only you can judge.

like image 70
David Nelson Avatar answered Oct 12 '22 01:10

David Nelson