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
The difference is that Full will always create a COM+ transaction context, and Automatic will create one when needed.
So, in a case that a COM+ Transac is needed, the primary difference is when the app take the performance hit, at the beginning of the transac (with Full), or in the moment is needed (with Automatic)
If you are certain that you will need a COM+ transaction, go for Full, but ... don't believe me:
Test! a lot!!