Re: MARS (Multiple Active ResultSets) and Transactions

Hi,

I did manage to fix the problem myself.

SqlMapper.ExecuteQueryForObject<T> wasn’t closing the DataReader. I changed the code so its closes the DataReader after fetching data and now it seems to work fine even with MARS turned off.

Thanks anyways.

Regards

Ananth

Hi,

 

I have a transaction being executed on my Data Access on Layer, with multiple updates (5). When MARS was turned off on execution of the Transaction, I got an error “ Open DataReader Associated, Command must be ClosedR21;. So I turned on MARS, and then on SqlMapper().CommitTransaction() it throws the error “Pending requests working on this Tranasaction”.  I used sqlMapper().BeginTransaction() to begin the transaction

 

Has anybody encountered this problem before and solved it?

 

Regards

 

Ananth

 

Got a little couch potato?
Check out fun summer activities for kids.