Transactions with configured TableAdapters

[Shimon Sim]

Hi
I followed some walkthrough for creating Typed Dataset and TableAdapters.
One thing I can't figure out is how to use transactions with generated Table
Adapters.
Any ideas?
Thanks,
Shimon

 

[Shimon Sim]

I figured that out. Just need to use TransactionScope.
Thanks

 

[Shimon Sim]

Now this didn't help.
I get error MSDTC on server 'SIATA' is unavailable.
What is next?
Thank you,
Shimon

 

[David Browne]

Now this didn't help.
I get error MSDTC on server 'SIATA' is unavailable.
What is next?

You need to extend the TableAdapter partial classes to reuse a single
connection to prevent DTC promotion

Per
http://blah.winsmarts.com/2006/06/18/the-definitive-tableadapters--transactions-blog-post.aspx

David

 

[Shimon Sim]

Thanks
Shimon

You need to extend the TableAdapter partial classes to reuse a single
connection to prevent DTC promotion

Per
http://blah.winsmarts.com/2006/06/18/the-definitive-tableadapters--transactions-blog-post.aspx

David

 

[Shimon Sim]

For Those interested.
My scenario is different from the example since I had to maintain
transaction through different adapters.
SO we just create new file and declare partial class. Make sure to have
correct namespace and class name.
Then I introduce following method
public void InitializeTransaction(SqlConnection connection, SqlTransaction
transaction)

{

_connection = connection;

this.Adapter.InsertCommand.Transaction = transaction;

Adapter.UpdateCommand.Transaction = transaction;

Adapter.DeleteCommand.Transaction = transaction;

foreach (SqlCommand command in CommandCollection)

{

if (command.CommandText.ToUpper().StartsWith("INSERT")) //this is for custom
queries. You mane need to have different checks here

{

command.Transaction = transaction;

}

}

}

That is it.
Now just create connection and transaction and pass it to addapter before
calling any dataaccess methods.

 

[Jeff]

a