protected Query(IDbConnection conn, SqlProvider <T> sqlProvider)
{
SqlProvider = sqlProvider;
DbCon = conn;
}
protected Option(IDbConnection conn, SqlProvider <T> sqlProvider) : base(conn, sqlProvider)
{
}
public int Insert(T entity)
{
SqlProvider.FormatInsert(entity);
return(DbCon.Execute(SqlProvider.SqlString, SqlProvider.Params));
}
protected Order(IDbConnection conn, SqlProvider <T> sqlProvider) : base(conn, sqlProvider)
{
OrderbyExpressionList = new Dictionary <EOrderBy, LambdaExpression>();
}
public int Update(Expression <Func <T, T> > updateExpression)
{
SqlProvider.FormatUpdate(updateExpression);
return(DbCon.Execute(SqlProvider.SqlString, SqlProvider.Params));
}
public int Delete()
{
SqlProvider.FormatDelete();
return(DbCon.Execute(SqlProvider.SqlString, SqlProvider.Params));
}
public int Update(T entity)
{
SqlProvider.FormatUpdate(a => entity);
return(DbCon.Execute(SqlProvider.SqlString, SqlProvider.Params));
}
protected Command(IDbConnection conn, SqlProvider <T> sqlProvider) : base(conn, sqlProvider)
{
}
public bool Exists()
{
SqlProvider.FormatExists();
return(DbCon.QuerySingle <int>(SqlProvider.SqlString, SqlProvider.Params) == 1);
}
public TResult Sum <TResult>(Expression <Func <T, TResult> > sumExpression)
{
SqlProvider.FormatSum(sumExpression);
return(DbCon.QuerySingle <TResult>(SqlProvider.SqlString, SqlProvider.Params));
}
public int Count()
{
SqlProvider.FormatCount();
return(DbCon.QuerySingle <int>(SqlProvider.SqlString, SqlProvider.Params));
}
