Bug #94010 .Net and MySQL, no support for multiple active result sets.
Submitted: 23 Jan 2019 6:11 Modified: 23 Jan 2019 6:56
Reporter: Sachin Erande Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / NET Severity:S4 (Feature request)
Version:8.0.13, ALL OS:Any (ALL)
Assigned to: CPU Architecture:Any (ALL)
Tags: .Net and MySQL, no support for multiple active result sets.

[23 Jan 2019 6:11] Sachin Erande 
Description:
Hello, 
.Net and MySQL, no support for multiple active result sets.
this is known problem with MySQL connection from ado.net. (SQL Server supports it, by introducing "multipleactiveresultset=true" in the connection string.)

when it is planned to be delivered, absence of this, needs to load all results in memory resulting into bottleneck, and theirby no support for lazy loading.

please have a look and introduce the feature. kindly confirm me status about it.
Thanks.

How to repeat:
Known problem and developers are aware of it.

using ADO.Net open two datareaders under single database connection.
while opening second reader problem occurs.

Suggested fix:
MySQL team, to introduct feature to support multiple active results set similar to SQL Server.
[23 Jan 2019 6:56] MySQL Verification Team 
Hello Sachin Erande,

Thank you for the feature request!

regards,
Umesh
[23 Jan 2019 7:01] MySQL Verification Team 
Bug #77610 marked as duplicate of this one