Linq to Sql profiler – transactions

time to read 1 min | 127 words

Well, here is a new thingie, L2SProf can now detect transactions.

Both standard SQL transactions:


And also distributed transactions using System.Transactions:


This is an interesting feature, because you can see how the use of different transaction strategies have a big impact on how you structure your code.

For example, with L2S, it seems like you are encouraged to read outside of a transaction. Something that I, as an NHibernate user, find quite odd.