EF Usage

Nov 22, 2012 at 9:37 AM

hello, im new to ASP.NET but not .NET as a whole. Is there any reason Entity Framework wasnt used for PF? Looking at your database layer, you use a datareader. In my research it seems like there is a big push to EF and there have been a lot of performance improvements by MS recently.

I have no strong views either way but thought you would be better qualified to answer the question.


Nov 23, 2012 at 12:12 AM

As mentioned in the FAQ, the app predates most ORM's, so retrofitting it would be kind of a waste of effort. Most of the modern ORM frameworks perform pretty well, but they won't ever work as efficiently as straight SQL because they can't possibly guess how best to tweak the queries for your specific use case.

I'm not dogging EF. I like EF, and I use it in pretty much all of my other projects. I just don't have a good reason to start using it in data access code that has been around, in parts, for ten years.