Hello, I'd like to know if anyone has crossed with this issue, In my application i'm using with isolation level = SnapShot, and then i using this transaction to create a external component include in such transaction, using System.EnterpriseServices.ITransaction estx; estx = (System.EnterpriseServices.ITransaction)TransactionInterop.GetDtcTransaction(Transaction.Current);
when I've reach to this point a " Transaction with isolation level = snapshot cannot promote". If I change the isolation level to serializable, then the process runs, but i'd like to keep the transaction isolation level.
Hi Xiao, System.Transaction as such doesn't use/depend on Isolation level. It passes the Isolation level to the Resource Manager(SQL). I am assuming you are using SQL, when do you get the exception? Has SQL been initalized with a different Isolation level and trying to change the isolation level?
You can also ask SQL experts in SQL forum about this behavior.