Page 1 of 1

Multiple open DataReaders

Posted: Fri 04 Nov 2005 22:04
by adriana
Will the ADO.net 2.0 provider support multiple open datareaders?

Standard OleDB/Oracle drivers support it, and the SqlClient supports it with MARS...

Thanks

Posted: Tue 08 Nov 2005 08:00
by Serious
This behavior does not depend on .NET Framework version, this is the restriction of MySQL Server protocol.
To use multiple open datareaders you have to set MySqlCommand.FetchAll = true. For more information about this property refer to MySQLDirect .NET documentation.