WebApi Lazy Loading

Question

I'm just starting out with ASP.NET MVC WebApi and EntityFramework and wanting to use a data-first model to bring objects out of an existing database. This works fine but it takes a decently long time to bring back the data with only 500 records because the data is related over several tables. I want it to bring back only the main table in my pull for performance in searching, so I do something like this:

    // GET: api/Cases
    public IQueryable<Case> GetCases()
    {
        db.Configuration.LazyLoadingEnabled = true;
        db.Configuration.ProxyCreationEnabled = true;
        return db.Cases;
    }

However, it's still pulling back all of the related tables. Any idea how to change that?

ErikEJ · Accepted Answer · 2017-03-24 20:09:57Z

2

public List<Case> GetCases()
{
    db.Configuration.ProxyCreationEnabled = false;
    return db.Cases.AsNoTracking().ToList();
}

edited Mar 24, 2017 at 20:09

answered Mar 24, 2017 at 20:00

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

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

2 Comments

John Ernest Over a year ago

That brought me back this error in my JSON return: "innerException":{"message":"An error has occurred.","exceptionMessage":"When an object is returned with a NoTracking merge option, Load can only be called when the EntityCollection or EntityReference does not contain objects." I'm not sure what that means exactly.

ErikEJ Over a year ago

Updated my reply

Collectives™ on Stack Overflow

WebApi Lazy Loading

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related