protected void Execute(Action <DALDataContext> work)
{
DALDataContext ctx = DAL;
using (IDbConnection conn = ctx.Connection)
{
work(ctx);
}
}
protected T ExecuteNoLock <T>(Func <DALDataContext, T> work)
{
DALDataContext ctx = DAL;
T retval = default(T);
using (IDbConnection connection = ctx.Connection)
{
ctx.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;");
retval = work(ctx);
}
return(retval);
}
protected T Execute <T>(Func <DALDataContext, T> work)
{
try
{
DALDataContext ctx = DAL;
T retval = default(T);
using (IDbConnection connection = ctx.Connection)
{
retval = work(ctx);
}
return(retval);
}
catch (Exception ex)
{
using (StreamWriter sw = new StreamWriter(string.Format("{0}logs.txt", AppDomain.CurrentDomain.BaseDirectory)))
{
sw.WriteLine(ex.ToString());
}
throw;
}
}
