Error: ASP.NET: 'DataContext accessed after Dispose.'

There are two tables: Account (id) and BranchId(Id,Name,AccountId) and I have this code in pageload

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
       using (v开发者_如何学Car db = new SitesDataContext())
       {
           BranchGrid.DataSource = db.Branches.Where(b=>b.AccountId == loggedInUser.AccountId).ToList();
                    BranchGrid.DataBind();
       }
    }            
}

I understand about Linq and lazy loading and that is why I used ToList() But I was still getting error.

Now if I remove the association b/w Branch and Account, the above code works fine. However it throws exception with the association.

How can this be resolved while still keeping the association?

Thanks

Even with the ToList() your Accounts are not eagerly loaded, only the Branches

You can either:

• remove the using {} and let the garbage collector do its job

or

• add LoadOptions to the datacontext to eager load the Accounts with the branches (something like this)

   DataLoadOptions options = new DataLoadOptions();
   options.LoadWith<Branches>(b => b.Account);
   Context.LoadOptions = options;
  

Somewhere, the Account property of a Branch instance is being accessed. You must locate the code that is accessing that property and stop it.