Does SqlConnection.Dispose() perform a rollback on all pending transactions?

Question

Possible Duplicate:
What happens to an uncommitted transaction when the connection is closed?

I know a SqlTransaction will rollback itself on Dispose() (see Will a using statement rollback a database transaction if an error occurs?), but will it be rolled back when its parent SqlConnection is disposed?

Have you tried it to see? – Jon Egerton Feb 01 '13 at 09:26 — Jon Egerton, Feb 01 '13 at 09:26

score 4 · Answer 1 · answered Dec 13 '12 at 18:21

4

Yes, but I don't think it is handled by SqlConnection class.

I think it's SQL Server that when the connection is closed automatically roll back all not committed transactions.

Also consider that SqlConnection has a connection pool by default. So it is possible that when you close/dispose a SqlConnection the "real" db connection is still active.

answered Dec 13 '12 at 18:21

Davide Icardi

11,919
8
56
77

3

In fact, the tran will stay open until the connection is reused! – usr Dec 13 '12 at 18:38

Does SqlConnection.Dispose() perform a rollback on all pending transactions?

1 Answers1

Linked