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-28T10:06:53.033

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 '13 at 10:06

answered May 28 '13 at 09:46

sexta13

1,558
1
11
19

I have not this propery in the properties of the edmx. I have only compile action, copy in the result folder, tool for namespace, custom tool, file name and the path. – Álvaro García May 28 '13 at 09:50
2

@Á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. – Maarten May 28 '13 at 09:54
1

You have to open the edmx, and then press F4 (for properties) – sexta13 May 28 '13 at 09:54
The value in the properties of the edmx was true, I changed it to false but when I create a new dbContext, it has the lazy loading to true. – Álvaro García May 28 '13 at 10:01
1

Did you made a clean solution and rebuild? do you create the dbcontext how? like this: using (SergioEntities dm = new SergioEntities()) { } – sexta13 May 28 '13 at 10:04
I delete my edmx and created it again. I select the connection and the databse in the wizzard. When The edmx is created, I change the lazy loading property in the edmx. The designer.cs file has in thethree constructors the lazyLoadingEnabled = false, but this code is never executed. – Álvaro García May 28 '13 at 10:08
1

and when you put a breakpoint like i did in the image you see lazyloading = true? – sexta13 May 28 '13 at 10:13
1

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... – sexta13 May 28 '13 at 10:17
Thanks. It is very strange. really I don't know what constructor is used to create the dbContext. – Álvaro García May 28 '13 at 10:24
1

One last question, are you using 4.5 or 4.0? if it is 4.5, you can try this last thing. delete the .tt files under EDMX file and again on properties put the code generation strategy to default. Try it out :) – sexta13 May 28 '13 at 10:34
I am using EF 4.0. Well, the library 4.5 for C# 4.0, it could see it as EF 4.4. But the problem persists. Thank again. – Álvaro García May 28 '13 at 11:25

score 1 · Answer 2 · edited May 23 '17 at 11:57

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 '17 at 11:57

Community

1
1

answered May 28 '13 at 09:43

Eoin Campbell

43,500
17
101
157

I have this line: but annotation gives me an error: the prefix is not definied. – Álvaro García May 28 '13 at 09:47

StuartLC · Answer 3 · 2013-05-28T11:20:11.333

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;    
}

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

3 Answers3