tag:blogger.com,1999:blog-11096258.post113861460681808955..comments2024-03-26T09:29:25.252+01:00Comments on InfoWorker Solutions: System.Transactions LTM - promoting to DTCKjell-Sverre Jerijærvihttp://www.blogger.com/profile/13654217591841196465noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-11096258.post-1143893803270222582006-04-01T14:16:00.000+02:002006-04-01T14:16:00.000+02:00The ADO.NET team has provided an unsupported worka...The ADO.NET team has provided an unsupported workaround for the LTM limitation. See more info and link at http://kjellsj.blogspot.com/2006/04/systemtransactions-nesting-scopes.htmlKjell-Sverre Jerijærvihttps://www.blogger.com/profile/13654217591841196465noreply@blogger.comtag:blogger.com,1999:blog-11096258.post-1142796265550559602006-03-19T20:24:00.000+01:002006-03-19T20:24:00.000+01:00I have to admit that we use a DataSession object w...I have to admit that we use a DataSession object with a SqlConnection property that we assign an open connection. This session object is passed around, and then assigned to the Connection property as applicable.<BR/><BR/>This is a temporary solution while we are crossing our fingers and hoping/waiting for Microsoft to allow LTM for multiple, identical connections to a single SS2K5 database.Kjell-Sverre Jerijærvihttps://www.blogger.com/profile/13654217591841196465noreply@blogger.comtag:blogger.com,1999:blog-11096258.post-1142612046176189702006-03-17T17:14:00.000+01:002006-03-17T17:14:00.000+01:00I am in the same boat. Did you come up with any al...I am in the same boat. Did you come up with any alternative solution for using table adapters and transaction without escalating to MSDTC? It's hard to believe tha MS ignored this issue and it's killing use of typed datasets.Anonymousnoreply@blogger.com