tags:

views:

21

answers:

0
Q: 

EF4 prevent child entity attached

We have a situation with a fairly complex entity/table hierarchy modelled with EF4. Often we like most of the associations to load (whether lazy or not) and are happy with that.

Sometimes we want just the top of the hierarchy and maybe one or two of the related detail tables to be attached. For example when returning a set from a WCF method - as expected it will load every associated entity on the spot where often we just need a couple of them.

I know we can do this with projection but that seems to be a third slower than the regular query. I think we can also "clear()" the detail entity sets we do not want but that also would be a performance hit.

It seems crazy we can't pull the entity as normal and just prevent lazy loading from ocurring, or prevent selected details from ever being attached. I think I am missing a simple thing.

Your help is appreciated

related questions

Linq To SQL Without Explicit Foreign Key Relationships
Creating a form for a new associated object using the Rails 2.3 model nesting.
Registering an application to open specific web links
Add shortcut methods or follow ActiveRecord semantics?
Error when creating associated objects in Rails
Why doesn't this associated create call work?
Better Performance on Associations
Accessing associations in Rails
Elegantly selecting attributes from has_many :through join models in Rails
How can I define a polymorphic relation between models in Django?
UML class diagram association - how, when and why?
ActiveRecord has_n association
Rails ActiveRecord Update question
Rails: How to observe join records that don't actually have a Model?
Entity Framework - how do I use the entity associations?
Problem with self-referential has_many :through associations in Rails
Rails JOIN TABLES
LINQ to SQL - Nullable INT in ForeignKey = "Cannot create an association..."
How do you run a "do" block in a Rails Model while still listing a :dependent?
How to achieve versioned ActiveRecord associations?
Activerecode HABTM primary key problem
Are there any good professional associations for IT Managers/Programmers?
LINQ to SQL associations - how to change the value of associated field
Generic Java Framework to Manage Bidirectional Associations and Inverse Updates
When deleting hasOne or hasMany associations, should the foreignKey be set to NULL?