• Register
0 votes

Problem :

My Query is giving the strange error as follows
there is already an open datareader associated with this command which must be closed first.
6 5 3
6,930 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

This issue can happen if you are executing a Query while iterating over the results from another Query. 

Please note that a cause of this can be lazy loading triggered when iterating over the results of some of the query.

It can be solved easily by allowing MARS in your connection string. Please add MultipleActiveResultSets=true to your provider part of the connection string where you are spacifying the Data Source, Initial Catalog, etc. 

This will surely resolve your issue.

9 7 4
38,600 points

Related questions

0 votes
2 answers 718 views
Problem : I want to save on the DB the log of a multi threaded processor but I am facing the following error: new transaction is not allowed because there are other threads running in the session. In each tread I have following function : internal bool WriteMyTrace(IResult ... for each of the threads, but there connection with my DB is always in the same way. Anyone have solution on my problem?
asked Dec 5, 2019 alecxe 7.5k points
0 votes
1 answer 86 views
Problem : I have one entity type called product which is generated by the entity framework. I have tried to write below query public IMyQueryable<Product> GetProducts(int myCategoryID) {     return from prod in db.Products     where prod.CategoryID== myCategoryID     select ... one select new Product { Name = p.Name}; it miraculously works correctly. How can I perform the custom select section?
asked Jan 27, 2020 jwilliam 3.9k points
0 votes
1 answer 142 views
Problem : I am getting bellow error related to datetime the conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
asked Nov 7, 2019 peterlaw 6.9k points
0 votes
2 answers 347 views
Problem : Currently I am migrating from the Identity 1.0.0 to Identity 2.0.1. But the migrations code generated is nothing about the new IdentityUser. And It does not even add the new columns. So I tried to make the new project and also I ... current context At below line IdentityResult result = await UserManager.CreateAsync(user, model.Password); Any clue about the solution on my above problem?
asked Dec 25, 2019 alecxe 7.5k points
0 votes
1 answer 760 views
Problem : I am having the table with the name EducationTypes and also an Entity named as EducationType, I just tried to rename the one of the entity properties but now I am always facing following error : Either the parameter @objname is ambiguous or the ... SQL Script is as below: EXECUTE sp_rename @objname = N'dbo.EducationTypes.nvarchar', @newname = N'EducationTypeTitle', @objtype = N'COLUMN'
asked Dec 9, 2019 alecxe 7.5k points
0 votes
1 answer 553 views
Problem : When I am attempting to connect to MSSQL database via ASP.NET online, I will often get the below error when two or more people try to connect simultaneously: ExecuteReader requires an open and available Connection. The connection's current state is Connecting. My site works fine on the localhost server. May I know what might have gone wrong with my site and how can I fix the error?
asked Jan 31, 2020 jwilliam 3.9k points
0 votes
1 answer 2 views
Problem: the provider did not return a providermanifesttoken string.
asked 5 days ago Dan phillip 1.9k points
0 votes
1 answer 14 views
How can i apply any entity framework approach like code first and database first in the ASP.NET MVC application.
asked Sep 16, 2020 Daniel Anderson 4k points
0 votes
1 answer 30 views
Problem: Currently I have the table called Student in the database with some of the values and I am trying to display the values in the webgrid with the help of entityframework. I have done exactly the same kind of work before many times using the Ado.net, but ... I assign the VAR value to List also is this my correct approach? Kindly guide me in fixing my problem related to Entity Framework.
asked Jul 3, 2020 Raphael Pacheco 4.9k points