Disable Lazy Loading for a specified query

Question

Disable Lazy Loading for a specified query

Navigation

#1 by (3 votes)

1

I'm having a sloppy problem when it comes to fetching the data.

I have 16 thousand records in the table that are taking about 6 seconds to be fetched.

I noticed that while bringing these records this is also bringing the related records due to lazy loading . However, in this particular query there is no need to bring related records.

I think I might gain some time if I do not bring these unnecessary records, follow the code:

public IList<NotaMercadoria> GetAll(long pIdCadEmpresa)
{
    return entity.NotaMercadoria.Where(x => x.IDCadEmpresa == pIdCadEmpresa).ToList();
}

Since there is no need to bring related records, is there any way to disable lazy loading for this query in specifies?

c# entity-framework

asked by anonymous 28.09.2017 / 20:17

1 answer

Get a word from a variable that has more than one word, with jQuery Compare if two date fields are the same in C #

score 3 · Accepted Answer

Just disable it before fetching the data.

public IList<NotaMercadoria> GetAll(long pIdCadEmpresa)
{
    entity.Configuration.LazyLoadingEnabled = 
    entity.Configuration.ProxyCreationEnabled = false;

    return entity.NotaMercadoria.Where(x => x.IDCadEmpresa == pIdCadEmpresa).ToList();
}