|I do transaction in the business layer, and I use EntLib's DAAB.
This gives me some problems, namely a InvalidOperationException: "ExecuteNonQuery requires an open and available Connection. The connection's current state is closed."
I've tried both using the TransactionScope, and the ServiceConfig way of doing COM+ transactions.
It works fine without the transaction stuff.
I'm well aware that the connection gets closed since I do transaction from the business layer, but that should be possible, even if it then becomes a distributed transaction.
As I mentioned I'm also using the Enterprise Library Data Access Application Block, and Im'm wondering if that's what screwing things up.
Any good advice?
"When you have made evil the means of survival, do not expect men to remain good. Do not expect them to stay moral and lose their lives for the purpose of becoming the fodder of the immoral. Do not expect them to produce, when production is punished and looting rewarded. Do not ask, `Who is destroying the world?' You are."
-Atlas Shrugged, Ayn Rand