one transaction for more databases

Question

User1049072584 posted

 Hi,

Can I have one transaction for more databases? Is it possible? How I do it in C#?

Thanks a lot

Answer 1

User-1085149042 posted

Yes... it is possible. This can be achieved using TransactionScope object in C#.

 

Answer 2

User1049072584 posted

 thanks

I'm trying it now.

Answer 3

User1024576976 posted

You can have transaction objects for different database.

Place each transaction object in transaction array and when you completed your required transaction then fetch each transaction object and call commit.

 

Thanks

 

Answer 4

User-1199946673 posted

Yes... it is possible. This can be achieved using TransactionScope object in C#.

As I remembered, TransactionScope can NOT be used with JET

If you have mulitple Access (Jet) databases, you could try to use only 1 (or create a new one), and link all tables of the other database(s) into this one. As a result, you could access all tables in multiple databases using 1 connection only, and you can use the OleDbTransaction object

Answer 5

User-1199946673 posted

Yes... it is possible. This can be achieved using TransactionScope object in C#.

As I remembered, TransactionScope can NOT be used with JET

If you have mulitple Access (Jet) databases, you could try to use only 1 (or create a new one), and link all tables of the other database(s) into this one. As a result, you could access all tables in multiple databases using 1 connection only, and you can use the OleDbTransaction object