public void TestContext(string context) { var ctx = new DataContext(context); ctx.GetTable<Person>().ToList(); ctx.KeepConnectionAlive = true; ctx.GetTable<Person>().ToList(); ctx.GetTable<Person>().ToList(); ctx.KeepConnectionAlive = false; using (var tran = new DataContextTransaction(ctx)) { ctx.GetTable<Person>().ToList(); tran.BeginTransaction(); ctx.GetTable<Person>().ToList(); ctx.GetTable<Person>().ToList(); tran.CommitTransaction(); } }
public void TestContext([IncludeDataContexts(ProviderName.SqlServer2008)] string context) { var ctx = new DataContext(context); ctx.GetTable<Person>().ToList(); ctx.KeepConnectionAlive = true; ctx.GetTable<Person>().ToList(); ctx.GetTable<Person>().ToList(); ctx.KeepConnectionAlive = false; using (var tran = new DataContextTransaction(ctx)) { ctx.GetTable<Person>().ToList(); tran.BeginTransaction(); ctx.GetTable<Person>().ToList(); ctx.GetTable<Person>().ToList(); tran.CommitTransaction(); } }
/// <summary> /// Starts new transaction for current context with default isolation level. /// If connection already has transaction, it will be rolled back. /// </summary> /// <param name="autoCommitOnDispose">Not supported, see <a href="https://github.com/linq2db/linq2db/issues/104">issue</a>.</param> /// <returns>Database transaction object.</returns> public virtual DataContextTransaction BeginTransaction(bool autoCommitOnDispose = true) { var dct = new DataContextTransaction(this); dct.BeginTransaction(); return(dct); }
/// <summary> /// Starts new transaction for current context with specified isolation level. /// If connection already has transaction, it will be rolled back. /// </summary> /// <param name="level">Transaction isolation level.</param> /// <returns>Database transaction object.</returns> public virtual DataContextTransaction BeginTransaction(IsolationLevel level) { var dct = new DataContextTransaction(this); dct.BeginTransaction(level); return(dct); }
public virtual DataContextTransaction BeginTransaction(bool autoCommitOnDispose = true) { var dct = new DataContextTransaction(this); dct.BeginTransaction(); return dct; }
public virtual DataContextTransaction BeginTransaction(IsolationLevel level) { var dct = new DataContextTransaction(this); dct.BeginTransaction(level); return dct; }