Posted by: YuvalShavit
Database development and architecture, ORM (Object-relational mapping)
SearchWinDevelopment.com’s recent story on Entity Frameworks missed some worthwhile commentary by DataFarm’s Julie Lerman. When we were pulling that together, data architecture expert Lerman was on the road, taking part in a variety of interesting projects and events, including the heralded Bloggers Roundtable with Bill Gates. (Check out the picture here.)
Lerman took some time at the end of her trip to e-mail us with some thoughts on the Entity Framework. Read these comments by Julie Lerman, and read ADO.NET Entity Framework Beta 3 ships; ups LINQ to SQL performance too.
On LINQ-to-SQL performance – Lerman discussed updates to Entity Framework that improve performance. She notes, too, that performance comparisons can sometimes mislead. She wrote:
If you are comparing LINQ to SQL with something like streaming data into a dataReader in ADO.NET, you will get different performance, but this is not at all comparing apples to apples. I do know that using Compiled Queries in LINQ to SQL will result in major performance improvements. Entity Framework now has Compiled Queries as well.
ASP.NET, EF, and the Model View Controller – She wrote:
While you can plug EF into ASP.NET very easily, there are two scenarios that take a bit of finagling – caching data and moving data across tiers. The n-tier issue is not only for ASP.NET of course, but is only really an issue if you are dealing with concurrency and need to maintain the state of data with respect to original values and current values.
And, regarding the Model View Controller for ASP.NET …
It has huge appeal to people who were doing web development before ASP.NET came out because of the return to the purity of stateless pages vs. all the hair-pulling around trying to fake persistence across post backs. Right now LINQ to SQL seems to be the DAL of choice for MVC but it will work with any ORM tool that exposes .NET Objects, so LINQ to Entities falls into that category as well. I haven’t played with any of these bits yet.
We also asked Lerman if she had any general comments on Entity Framework. She wrote:
I’m really pleased that Entity Framework Beta 3 is finally out along with the new CTP of the tools. I hope that at this point, people have stopped worrying that Entity Framework will go the way of ObjectSpaces, because it absolutely will not. The team has been very responsive to feedback and the v1 of Entity Framework will be a lot further along than they had originally planned for v1.