public void TestContext()
{
var ctx = new DataContext("Sql2008");
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 DataContextTransaction BeginTransaction()
{
var dct = new DataContextTransaction(this);
dct.BeginTransaction();
return(dct);
}
public DataContextTransaction BeginTransaction(IsolationLevel level)
{
var dct = new DataContextTransaction(this);
dct.BeginTransaction(level);
return(dct);
}
public DataContextTransaction BeginTransaction()
{
var dct = new DataContextTransaction(this);
dct.BeginTransaction();
return dct;
}
public DataContextTransaction BeginTransaction(IsolationLevel level)
{
var dct = new DataContextTransaction(this);
dct.BeginTransaction(level);
return dct;
}