I want to insert multiple records in one transaction to MsSqlServer & Neo4j.
First one to MsSqlServer, second one to Neo4j, third one to MsSqlServer again, and so on..
But if one of the insertions fails, all the previous insertions should be cancelled.
Can i use one TransactionScope object for MSSQLServer and Neo4j operations to manage the transaction easily?
Meaning one distributed transaction for these 2 systems, I suppose..
Is it possible?