LINQ Join Throws An Error Saying "There is already an open DataReader associated with this Command which must be closed first"

Question

I have a Linq join and have populated viewmodel using that join. On running, there is an error on that join saying

There is already an open DataReader associated with this Command which must be closed first

Below is my join

public List<GallerySisterComanyVM> GetAllGallery()
{
    var list = (from GI in uow.Repository<GalleryImage>().GetAll()
        join SC in uow.Repository<SisterCompany>().GetAll() on GI.SisterCompanyId equals SC.SisterCompanyId
        select new GallerySisterComanyVM
        {
            GalleryImageId=GI.GalleryImageId,
            Status=GI.Status,
            Image=GI.Image,
            SisterCompanyName=SC.SisterCompanyName
    }).OrderByDescending(x=>x.GalleryImageId).ToList();

    return list;
}

Did this solve your issue?Refer to:https://stackoverflow.com/a/6064422/11398810 — Rena, Feb 05 '20 at 07:54

JMP · Answer 1 · 2020-02-04T14:49:10.193

0

Assume it is due to the first repository query still running when the second is called. How about querying the context directly instead of the repository, or create the joined query in the repository as a separate method?

edited Feb 04 '20 at 14:49

answered Feb 04 '20 at 14:41

JMP

1,864
2
8
16

score 0 · Accepted Answer · answered Feb 04 '20 at 14:48

Check your web.config or .json secrets configuration file for the SQL connection string used to start the Context and look for the "MultipleActiveResultSets=True" bit.

If this doesn't exist, try adding it to the end of your SQL string and try again.

See here for details

LINQ Join Throws An Error Saying "There is already an open DataReader associated with this Command which must be closed first"

2 Answers2