Alternative to Save point when using System.Transactions

Question

How can I use classes from System.Transactions namespace to achieve similar effect as I can get when using SqlTransaction.Save(savePoint) and SqlTransaction.Rollback(savePoint). The effect of using these two methods is ability to create named save point in the running transaction and in case of issue rollback only to the save point (operations created before save point are not rolled back).

Answer 1

Save Points are database specific in part of their implementation. Oracle implements them, and apparently so does SQL server.

System.Transactions is designed for full-bore transactions, and not intermediate save points along the way of a transaction.

Alas, because it would be nice to have this feature in the lowest-common denominator database supported: ACCESS JET.

Answer 2

yourcontext.Database.ExecuteSqlCommand(string.Concat("save transaction ", savePoint));

yourcontext.Database.ExecuteSqlCommand(string.Concat("rollback transaction ", savePoint));