Using existing connection and transaction with QueriesTableAdapter queries
Posted by: Matt Benic
Date: January 06, 2010 07:45AM

I have used Visual Studio's visual datasource editor and added two queries (to make use of stored procedures). I've run into a problem that I require the queries to be executed within a transaction I have already created, and as such need them to use the connection and transaction I've created. The command objects are automatically initialized to use a new connection, and unlike other TableAdapter objects, the QueriesTableAdapter doesn't expose the connection and transaction objects used by it's commands, is there any clean way to modify these?
At a push I suppose I could extend the QueriesTableAdapter class and override the CommandCollection property to be public, but since I'd then be referencing the command objects by array index, this really seems a bit messy.

Any suggestions would be greatly appreciated :)

Options: ReplyQuote

Written By
Using existing connection and transaction with QueriesTableAdapter queries
January 06, 2010 07:45AM

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.