Last post Dec 19, 2008 01:57 PM by Nannette
Oct 30, 2008 05:58 PM|rscott|LINK
So... I've bumped into a number of problems in the Entity Framework that are becoming a real discouragement from me using it at all. I'm wondering, since the only official forum dedicated to the EF is lised as "Preview" is this really released officially
or is it indeed in preview more.
Is there some place that gets more traffic by the developers of the EF? Or some other forum that's more suited to issues that I find?
Nov 02, 2008 10:08 PM|MisterFantastic|LINK
Actually don't get discouraged. Its really amazing Framework. Please tell us your problems and we will try to solve that. It will be really challenging to work like that .
Nov 11, 2008 07:25 PM|Natural Cause|LINK
Please tell us your problems and we will try to solve that.
I've only been playing with the Entity Framework for a few weeks so maybe i've missed something but:
1) Having to load a relating entity to save an entity.
A product with a category, what i have to do...
product.Category = entity.Category.First(s => s.CategoryID == categoryID);
What i want to do...
product.Category.CategoryID = categoryID;
I haven't actually looked at SQL Profiler to see the SQL it generates so i only assume it loads the category entity before saving resulting in multple database hits?
2) Lack of lazy loading...
I don't like that i have to do...
foreach (OrderItems item in order.OrderItems)
3) I liked how LINQ2SQL made all the objects/entities singular / plural...
So i select a Product from Products, as aposed to now which it's all plural so i select a single Products from Products...
A side note, updating an entity model is VERY buggy. If you drop a constraint in the database, this doesn't get updated in the entity model, if you drop a column, doesn't get updated in the entity model. In addition tables with relationships to themselves
result in entity relationships being named as the entity with a number on the end. You cannot update this information correctly when modifying the properties of an entity.
Dec 11, 2008 10:29 AM|admiller97|LINK
Ditto comments from Natural Cause (especially points 1 and 3). Might I also add: Why are return types for Stored Procedures not automatically generated?
Dec 19, 2008 01:57 PM|Nannette|LINK
You're right. I've found the ado.net entities discouraging as well.
Since you were told to ask questions and they'd be answered, I guess I'll just start asking and hopefully get some answers.
I'll start a new post so I can flag my answers as completed.