Re: DbProviderFactory and transactions.

Yes - I *believe* that doing an INSERT with a SELECT clause should
take out the lock from the outset ("key range" or equivalent, I
suspect), removing the need for UPDLOCK to prevent escalation
deadlocks [let me know if you want an explanation]. Your approach
looks reasonably sound (from the detail give); the TransactionScope
(at serializable isolation - the default) should make life pretty
simple for you; this deliberately causes blocking (as necessary) to
prevent concurrency chaos from competing connections.

Marc


.

Relevant Pages