SqlTransaction: Why is TableAdapter in generated dataSet.Designer.cs protected

Hot Topic

WebService not found when acessed via reverse proxy
memory leak in window.open() method
Start IE with results of WebRequest
Is File Path longer than 260 characters allowed in .Net 2.0 ?
TableAdapter Update problem
10060 Socket Error in Remoting
inner join usage
Using Generics with a DataGrid Control Returning an Index -1 after appending to the Collection
CLR Debugging service error
Web Service access.

.NET Development

Convert an int in string(hexaformat)
Multi-threading in javascript
Limiting available Ciphers with SslStream
Will AnyCPU cause binaries to run as 64-bit on x64 machine
Problems reading array in struct
Convert XML to Excel spreadsheet using XSLT
URGENT:System.Resources.ResXResourceWriter
bug in serialport.close() ?
redistribution software C# and J#
Validators in ASP.NET 2

SqlTransaction: Why is TableAdapter in generated dataSet.Designer.cs protected

In order to set the Transaction for a SqlCommand I have to get to the SqlCommand - Right

But I have not found a way to unprotect the Adapter inside the generated class...

Any ideas - workarounds

or "Am I evil " ;-)

Thanks
Peter

Answer this question

SqlTransaction: Why is TableAdapter in generated dataSet.Designer.cs protected

  • John Clark

    I have the same problem, I find this code but I don't know if this is the best way.

    Using transaccion As New Transactions.TransactionScope

    'Put your code here

    transaccion.Complete()

    End Using

  • Nathan Liebke

    You both should be using SQL Server stored procedures and using transactions there...not in your page code.

    Your approach is opening yourself widely for hacks and exceptions.

    Adamus



  • SqlTransaction: Why is TableAdapter in generated dataSet.Designer.cs protected
Answer this question