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

Re: Visual Studio 2008 TableAdapters and Transactions

Thanks for your reply Andrew,

So you originally have your own encapsulatd Transaction property which
conflict with the auto-genearted property in vs 2008, correct? If so, will
the auto-generated one fit your requirement since it also associate with
all the Commands object within the TableAdapter. You can use it to assign a
certain SqlTransaction. Or otherwise, you may using the
System.Transactions namespace's TransactionScope to perform transaction.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsoft.com.

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/de fault.aspx#notif
ications.

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "Andrew Jocelyn"
>References:

>Subject: Re: Visual Studio 2008 TableAdapters and Transactions
>Date: Mon, 31 Mar 2008 21:22:07 +0100
>
>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
>
>
>