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.