How do i set Savepoints for Linq to SQL and use "NO" ExecuteCommand ?
Posted
by nik
on Stack Overflow
See other posts from Stack Overflow
or by nik
Published on 2010-06-16T12:00:08Z
Indexed on
2010/06/16
12:02 UTC
Read the original article
Hit count: 227
TransactionScope TransactionABC = new TransactionScope();
try
{
context.Connection.Open();
{
context.ExecuteCommand("insert into test (test) values (1)")
context.SubmitChanges();
context.ExecuteCommand("savepoint test");
context.ExecuteCommand("insert into test (test) values (2)")
context.SubmitChanges();
context.ExecuteCommand("rollback to test");
}
TransactionABC.Complete();
TransactionABC.Dispose();
}
catch (Exception ec)
{
MessageBox.Show(" ", ec.Message);
}
finally
{
context.Connection.Close();
}
It works, but only with ExecuteCommand. I want to use a function, because i can't see what happens in the savepoint !
© Stack Overflow or respective owner