Using existing connection and transaction with QueriesTableAdapter queries

[Matt Benic]

Hi,
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 :)
Thanks,
Matt