Re: Visual Studio 2008 TableAdapters and Transactions

Hi Steven

Thanks for the information. Actually I'm only interested in grouping
TableAdapters into one SQL transaction. I have a solution using partial
classes with the code generated TableAdapter classes in VS2005. However,
VS2008 now generates a Transaction property which was breaking my code in
the partial classes because I already had a method called Transaction with
the same signiture. I was hoping that grouping TableAdapters together in
VS2008 might be easier so I just wondered if you had any suggestions.

Thanks
Andrew


.

Relevant Pages

  • Re: Avoiding escalation to MSDTC with multiple TableAdapter inserts
    ... make TableAdapters work with transactions with a minimal investment in code, ... >> partial, and you have access to the connection, I can see many different ... >> control, etc, to take implicit control over the implicit transaction ... >> big change in interface in an enterprise scale system to make sure all ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Avoiding escalation to MSDTC with multiple TableAdapter inserts
    ... - Sahil Malik ... > multiple TableAdapters with transactions? ... > partial, and you have access to the connection, I can see many different ... > handling - ie you're not managing the transaction itself, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Avoiding escalation to MSDTC with multiple TableAdapter inserts
    ... TableAdapters with transactions? ... have access to the connection, I can see many different ways of altering the ... managing the transaction itself, you are moulding the tableadapters into the ... >> is ensure that the first adapter's connection is open before it posts ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Re (by Cor): update DataSet - transaction
    ... But you also have to set Transaction object on Adapter Insert/Update/Delete ... commands, right? ... Why introducing TableAdapters when transaction is not provided for them? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Re (by Cor): update DataSet - transaction
    ... I thought that I remember it me again, just setting the connection in your ... second table adapter to the same as to the first, ... Why introducing TableAdapters when transaction is not provided for them? ...
    (microsoft.public.dotnet.framework.adonet)