how to disabled lazy loading for every instance of the dbContext?

Question

I have created an edmx and in the designer.cs file I have 3 constructors. In each constructor I add the followiing line:

this.Configuration.LazyLoadingEnabled = false;

However when I create a new DBContext the lazy loading is enabled because when I create a new DBContext is not used any of this constructors.

Which constructors is used to create a new DBContext?

EDIT: I am not using code first. I create my edmc from a SQL Server database.

Thanks.

sexta13 · Accepted Answer · 2013-05-28 10:06:53Z

3

You can go to the EDMX file, properties, and there's a property Lazy Loading. Just put it to false.

Regards,

==============EDIT===============

Don't you have this? enter image description here

==new EDIT== enter image description here

edited May 28, 2013 at 10:06

answered May 28, 2013 at 9:46

sexta13

1,5781 gold badge11 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Maarten Over a year ago

@ÁlvaroGarcía You have to click in the designer. What you see are the properties of 'just the file', not the properties of the current active object in the designer.

sexta13 Over a year ago

You have to open the edmx, and then press F4 (for properties)

sexta13 Over a year ago

Did you made a clean solution and rebuild? do you create the dbcontext how? like this: using (SergioEntities dm = new SergioEntities()) { }

sexta13 Over a year ago

and when you put a breakpoint like i did in the image you see lazyloading = true?

sexta13 Over a year ago

Then I don't understand. I have this: using (SergioEntities dm = new SergioEntities()) { bool test = dm.Configuration.LazyLoadingEnabled; } and test gives me false! I have just created a EDMX, add a table, and have put Lazy Loading Enable to false. It works...

|

Community · Accepted Answer · 2017-05-23 11:57:23Z

1

I think there's a property on the EDMX design time canvas properties to disable lazy loading. The edmx file has in the ConceptualModel and EntityContainer definition an attribute for lazy loading where you can set lazy loading generally to false:

<EntityContainer Name="MyEntitiesContext" annotation:LazyLoadingEnabled="false">

ref: Disable lazy loading by default in Entity Framework 4

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered May 28, 2013 at 9:43

Eoin Campbell

44.4k18 gold badges107 silver badges161 bronze badges

1 Comment

Álvaro García Over a year ago

I have this line: <EntityContainer Name="CMMSModelSqlServerEF44StoreContainer"> but annotation gives me an error: the prefix is not definied.

StuartLC · Accepted Answer · 2013-05-28 11:20:11Z

1

The property on the edmx design properties is called LazyLoadingEnabled - it defaults to true.

This is used in the T4 template (MyModel.Context.tt) as follows:

public <#=Code.Escape(container)#>()
    : base("name=<#=container.Name#>")
{
<#
    WriteLazyLoadingEnabled(container);
#>
}

Which will write out the following if the property is disabled:

this.Configuration.LazyLoadingEnabled = false;

If FWR the property isn't visible in the EDMX designer, you can remove the conditional code generation, and hard code it:

public <#=Code.Escape(container)#>()
    : base("name=<#=container.Name#>")
{
    this.Configuration.LazyLoadingEnabled = false;
    // more setup here, e.g. this.Configuration.ProxyCreationEnabled = false;    
}

edited May 28, 2013 at 11:20

answered May 28, 2013 at 9:44

StuartLC

108k18 gold badges225 silver badges295 bronze badges

Collectives™ on Stack Overflow

how to disabled lazy loading for every instance of the dbContext?

3 Answers 3

11 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

11 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related