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 292 times
1
Junior Mayhé
- 16,144
- 26
- 115
- 161
-
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
- 63,911
- 12
- 95
- 141