Using C#, is it possible to use OleDbTransaction to execute a insert in two different database vendors, such as Microsoft SQL Server and Oracle?
Asked
Active
Viewed 286 times
1
Junior Mayhé
- 15,769
- 26
- 111
- 159
-
similar: http://stackoverflow.com/questions/1063502/how-to-implement-transaction-over-multiple-databases – manji May 31 '11 at 18:01
1 Answers
0
Is it possible to use OleDbTransaction to save data in two different databases?
No because an OleDbTransaction is tied to a specific OleDbConnection. The only solution is to use TransactionScope (preferred solution) or the EnterpriseServices classes.
Thomas
- 62,492
- 11
- 93
- 137