Remove context awareness from Web API controller

Question

Suppose that i have

public IQueryable<Application> GetApplications() {
    var applications = _context.Applications.Where(v => v.Exported == false);
    // Now i want to flag exported = true because i am exporting them
    foreach (var application in applications){
        _context.Applications.SingleOrDefault(v => v.ApplicationId == application .ApplicationId).Exported = true;
}
    _context.SaveChanges();
    return applications;
}

I am not getting any applications because _context.SaveChanges(); ( i suppose) changed the applications variable. How can i change the Database without changing my local variable.

Well that seems very weird and should not happen. Make sure that applications is not empty collection at first line of method. — Alexander Polyankin
– Alexander Polyankin, Commented Jul 2, 2015 at 11:34
its not empty. while debugging i can see the applications variable populated and after SaveChanges applications is empty. — Iezekiel
– Iezekiel, Commented Jul 2, 2015 at 11:38

Alexander Polyankin · Accepted Answer · 2015-07-02 12:22:29Z

1

Call ToList to execute query before changing items:

var applications = _context.Applications.Where(v => v.Exported == false).ToList();

answered Jul 2, 2015 at 12:22

Alexander Polyankin

1,9421 gold badge17 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Remove context awareness from Web API controller

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related