I need to carry out some database updates, part of which will go through a COM+ component (that will be enabled for transactions), and others through standard LINQ to SQL, and I want both updates to part of one transaction.
I intend to use a TransactionScope to allow .NET and COM+ transactions to synchronise. However having read the documentation regarding EnterpriseServicesInteropOption, I am still uncertain of the differences between Automatic and Full.
Can I use Automatic in my case?
I can sense I may get a RTFM response, but I found this article unclear: http://msdn.microsoft.com/en-us/library/ms229974(VS.80).aspx
Any clearer resources people have would also be appreciated