MySQL Forums
Forum List  »  Connector/NET and C#, Mono, .Net

Advanced Search
New Topic

Re: How many DataReader can be associated a one Connection?
Posted by: Jean-Francois Mathieu
Date: December 28, 2004 09:55AM

Hi Oscar,

No you can only have one datareader connect to a connection at a time because the datareader open a connection stream on the connection to retreive the data and send it back to the application will it read. This is also why its faster than other data object.

To resolve this I usaly open a other connection if I need to do database manipuliation in the reader loop.

Happy holiday

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How many DataReader can be associated a one Connection?
Oscar Rodríguez
December 27, 2004 05:44PM
Re: How many DataReader can be associated a one Connection?
Jean-Francois Mathieu
December 28, 2004 09:55AM
Re: How many DataReader can be associated a one Connection?
Oscar Rodríguez
December 28, 2004 11:00PM
Re: How many DataReader can be associated a one Connection?
Jean-Francois Mathieu
December 29, 2004 08:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.