Stop EF From Loading Entities When Assigning Association

Question

Using Entity framework v4, and the POCO entity generator T4 templates.

The problem I have is that the Fixup methods are loading hundreds of entities when I assign an associated entity (see line 4 below).

Dim context = New SomeEntities
Dim list = context.Lists.FirstOrDefault(Function(l) l.ListId = 2)
Dim queryDetail = context.CreateObject(Of QueryDetail)()
queryDetail.CriteriaColumnType = context.CriteriaColumnTypes.FirstOrDefault(Function(cct) cct.CriteriaColumnTypeId = 145)

The CriteriaColumnType entity that is being assigned has a collection of QueryDetail objects, and when the assignment is made, the FixUp method on the CriteriaColumnType entity is lazy loading all of the associated QueryDetails.

How can I create the FK association and attach the CriteriaColumnType entity to my QueryDetail entity without loading all of the CriteriaColumnType's QueryDetail records?

Answer 1

Do you need lazy loading here? You can turn it off:

context.ContextOptions.LazyLoadingEnabled = false