public string Update(IDictionary <string, string> valueFields)
{
var SqlConsultant = SqlConsultantHelper.CreateCommander(Type, this.Configuration);
return(SqlConsultant.Update(
valueFields,
this.sExpression
));
}
public string Select()
{
var SqlConsultant = SqlConsultantHelper.CreateQuerier(Type, this.Configuration);
return(SqlConsultant.Select(
SqlEntityUtil.GetKeys <T>(this.Configuration),
this.sExpression,
this.Order));
}
public string Insert(T entity)
{
var SqlConsultant = SqlConsultantHelper.CreateCommander(Type, this.Configuration);
var value_keys = SqlEntityUtil.GetKeysValues(this.Configuration, entity);
return(SqlConsultant.Insert(
value_keys.Keys,
value_keys.Values));
}
public string Update(T entity)
{
var SqlConsultant = SqlConsultantHelper.CreateCommander(Type, this.Configuration);
var value_keys = SqlEntityUtil.GetKeysValues(this.Configuration, entity);
return(SqlConsultant.Update(
value_keys,
this.sExpression
));
}
public string Insert(T[] entities)
{
var SqlConsultant = SqlConsultantHelper.CreateCommander(Type, this.Configuration);
var values = entities.Select(x => SqlEntityUtil.GetValues(this.Configuration, x));
var keys = SqlEntityUtil.GetKeys <T>(this.Configuration, this.Configuration);
return(SqlConsultant.Insert(
keys,
values));
}
public string Sum <TReturn>(Expression <Func <T, TReturn> > property)
{
var SqlConsultant = SqlConsultantHelper.CreateQuerier(Type, this.Configuration);
return(SqlConsultant.Sum(ExpressionUtil.ToSqlSeleccion(property), this.sExpression, this.Group));
}
public string Fisrt()
{
var SqlConsultant = SqlConsultantHelper.CreateQuerier(Type, this.Configuration);
return(SqlConsultant.Fisrt(this.sExpression, this.Order));
}
public string Count()
{
var SqlConsultant = SqlConsultantHelper.CreateQuerier(Type, this.Configuration);
return(SqlConsultant.Count(this.sExpression, this.Group));
}
public string Delete()
{
var SqlConsultant = SqlConsultantHelper.CreateCommander(Type, this.Configuration);
return(SqlConsultant.Delete(this.sExpression));
}
