Breaking News: Grepper is joining You.com. Read the official announcement!

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

Add Answer

Vivacious Vendace answered on February 26, 2020 Popularity 10/10 Helpfulness 5/10

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

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

related There is already an open DataReader associated with this Connection which must be closed first.

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

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

Comment

  <connectionStrings>
    <add name="IdentityConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\IdentityDb.mdf;Integrated Security=True;MultipleActiveResultSets=true;" providerName="System.Data.SqlClient" />
  </connectionStrings>

Popularity 10/10 Helpfulness 5/10 Language csharp

Source: stackoverflow.com

Tags: c# command datareader this

Link to this answer
Share Copy Link

Contributed on Feb 26 2020

Vivacious Vendace

0 Answers Avg Quality 2/10

Closely Related Answers

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

Comment

Add this to your connection string:
MultipleActiveResultSets=true;

Popularity 10/10 Helpfulness 9/10 Language whatever

Source: Grepper

Tags: command

Link to this answer
Share Copy Link

Contributed on May 19 2021

Drab Dogfish

0 Answers Avg Quality 2/10

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

Comment

Add this to your connection string:
MultipleActiveResultSets=true;

Popularity 9/10 Helpfulness 6/10 Language whatever

Source: Grepper

Tags: connection c

Link to this answer
Share Copy Link

Contributed on Jan 11 2023

steve muland

0 Answers Avg Quality 2/10

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

Comment

This can happen if you execute a query while iterating over the results from another query. It is not clear from your example where this happens because the example is not complete.

One thing that can cause this is lazy loading triggered when iterating over the results of some query.

This can be easily solved by allowing MARS in your connection string. Add MultipleActiveResultSets=true to the provider part of your connection string (where Data Source, Initial Catalog, etc. are specified).

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: stackoverflow.com

Tags: command

Link to this answer
Share Copy Link

Contributed on Aug 16 2022

Pavel Dinh

0 Answers Avg Quality 2/10

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

Contents

More Related Answers

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

Closely Related Answers

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

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

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

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.