none
How to use SqlTransaction with multiple TableAdapters? RRS feed

  • Question

  • I have thre Table adapters for three different tables. One table is master table and two other tables are details table. this is what im doing

    1>MasterTableAdpter.Update(..)
    get the newly created primary key assign it to two detail tables
    2>DetailTableAdter1.Update(..)
    2>DetailTableAdter2.Update(..)

    How do i put evrything into one transaction?

    (NOTE: i may not be able to use TransactionScope becuase then i have to enable DTC service which i can not do on clients machine)

    Tuesday, December 7, 2010 10:42 PM

Answers

All replies