I am using linq and I am getting the error "There is already an open datareader associated with this command which must be closed first"

dc.Accounts.Where(a => blogs.Select(b => b.AccountID).Distinct()
           .Contains(a.AccountID));
foreach (Blog blog in blogs)
{
    blog.Account = accounts.Where(a => a.AccountID == blog.AccountID)
                           .FirstOrDefault();

    //this is done to access account outside ObjectContext
    blog.account = blog.Account;
}

In this code I am getting the value until the foreach loop blog, but then I am getting the error

There is already an open datareader associated with this 开发者_如何学编程command which must be closed first.

This is usually caused when you have an outer and inner query, and the outer is still running. Usually you can fix this by forcing the outer query to complete; simply adding ToList() is usually enough:

var blogs = dc.Accounts.Where(a => blogs.Select(b => b.AccountID).Distinct()
       .Contains(a.AccountID)).ToList(); // <======= here

You need to enable Multiple Active Result Sets.

Modify your connection string to enable MultipleActiveResultSets

string connectionString = "Data Source=MSSQL1;" + 
    "Initial Catalog=AdventureWorks;Integrated Security=SSPI" +
    "MultipleActiveResultSets=True";

Since you are accessing some navigational properties inside the loop you may be running into Select N+1 problem. You can avoid this by eager loading.

eg:

dc.Accounts.Include("Blogs").Where(a => blogs.Select(b => b.AccountID).Distinct()
           .Contains(a.AccountID));