Simple.Data's transaction is not work with non-dbo stored procedure using 0.19.0.0 from Nuget. My C# code as:
var db = Database.Open();
using (var transaction = db.BeginTransaction())
{
try
{
transaction.MySchema.Calculate();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}
The calculate stored procedure contains insert and update statements to add/modify many tables, when there is error raise in one table, it cannot be rollback the data modified or inserted.
Hi,
Simple.Data's transaction is not work with non-dbo stored procedure using 0.19.0.0 from Nuget. My C# code as:
var db = Database.Open(); using (var transaction = db.BeginTransaction()) { try { transaction.MySchema.Calculate(); transaction.Commit(); } catch { transaction.Rollback(); } }
The calculate stored procedure contains insert and update statements to add/modify many tables, when there is error raise in one table, it cannot be rollback the data modified or inserted.