SQLID SPID and Transaction Scope

Question

We are making multiple calls to SQL Server databases within a transaction using the entity framework.

Are we correct in assuming that the SPID will be held for the duration of the transaction and that all calls will be made with the same SPID?

+2

Shiraz bhaiji Apr 28 10 at 11:46

2 answers

Yes, the SPID will be the same for the duration of the transaction.

0

Barry king May 11 '10 at 11:53

Shiraz bhaiji · Accepted Answer · 2010-05-27T14:21:24+0000

We found out that the SPID is connected to a connection, not a transaction.

But EF will close and open the connection to enlist it in the transaction.

The connection is not actually closed, released to the connection pool and then loaded again.

The problem is that you cannot get the same connection from the connection pool, in which case you will not have the same SPID.