Not physically , but mentally i could've
I'm not much of a DOT net guy, but I did show this to someone who I think knows DOT net well, and he said that its not the answer to what I need.
MARS do provide what you asked for:
Execute multiple queries on a single connection simultaneously
And asynchronuos excecution is being supported even by ODBC since a long time ago therefore the key is not "asynchronuous". And what is more why do you need that again? What will be the problem of sending multiple select statements in one batch?
Eagerly waiting for poster reply
Can I specify the prefetch clause so that I can regulate (read increase) the number of rows of data that gets copied from the database to the client, as this would mean that I am copying more rows back to the client where by the efficiency could increase.
Just another school of though (might not be completely in line with what i had posted before).