title: Using datareaders with sqltransactions
body: <p>I am using <code>SqlTransaction</code>s in my code for roll back purpose. Within the transaction I got multiple statements to be executed with may include selects inserts and updates. All these statements are within the scope of the <code>sqltransaction</code>. Everything works fine just for one problem. I am using <code>datareader</code>s for select statements . And these readers are closed once they are used. This forces the connection to be lost and every thing fails. Does any one have a solution on whether I can use <code>datareader</code>s within a <code>sqltransaction</code>??</p>