Geeks With Blogs
Ankit Agrawal
At the beginning I want to inform that I've already read the similar question here: Entity Framework 4.0: is it worthy now? but it does not answer my questions and doubts concerning EF 4.0. Here's the case: We are working on a quite big project written in WPF and WCF. The structure of the database contains about 60 tables, lots of stored procedures, views and some functions. We are not using any ORM at the moment. Some time ago when the first version of EF was release we did not go with it because of the known reasons: 1. one threaded only (it uses only one processor core) 2. no support for lazy loading 3. no support for POCO 4. horrible designer 5. no support for foreign keys (as far as I remember) 6. horrible mappings support (as far as I remember I needed to use lots of hacks and workarounds) I think we can all agree that this version of EF was rather "TOY" than a reasonable "TOOL". I remember that calling SaveChanges() method on my entity model with a complex hierarchy took quite long time and looking at SQL Profiler I was confused seeing "SQL queries explosions". Therefore we decided to use repository pattern and repository locator pattern and write plain ADO.NET queries. This works fine so far, however sometimes we see that code maintence is hard. Additionally we use our own deserializers to materialize objects. At the moment we think about using Entity Framework 4.0. I know there are many improvements and enhancements in this framework and it's fine to use it in small projects. Therefore my question are: 1. what are pros and cons using EF 4.0 and what will be the consequence of using it in a bigger project? 2. how about SQL Queries generated by EF 4.0? Is the performance increased? 3. can EF 4.0 use all processor cores? 4. should we use it now or wait for EF 5.0 where Code first will be supported? Posted on Tuesday, September 20, 2011 4:16 AM | Back to top

Comments on this post: Use EF 4.0 or not ?

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © AnkitAgrawal | Powered by: