title: SQL Timeout after database exceptions
body: <p>I'm using Castle ActiveRecord as my ORM in my ASP.NET webapplication. I'm using their SessionPerRequest-approach and this works fine. However, if an error occures on the database-level (f.e. a constraint error when deleting an item or a truncation error (String or binary data would be truncated.)) I keep getting timeouts with all queries I run after the error. This happends for about ten minutes, then everything runs fine again. I think this has to do with the Transaction not closing correctly. I can't seem to find a way to correctly close the transaction after an error, so I'm looking now to minimize the effects. I've tried setting the Command Timeout and Connection Timeout to a smaller number, but this does not seem to work. Does anybody got an idea how to solve this problem?</p>