public int Count() { var count = 0; var sql = SqlQueryBuilder.Build(DataContext, Def); sql.AddAttribute("&Id", SqlQuerySummaryFunction.Count); using (var reader = new SqlQueryReader(DataContext, sql)) { reader.Open(); if (reader.Read()) { if (!reader.IsDbNull(0)) { count = reader.GetInt32(0); } } reader.Close(); } return(count); }
public T Sum <T>(string attrDefName) { T result = default(T); var sql = SqlQueryBuilder.Build(DataContext, Def); sql.AddAttribute(attrDefName, SqlQuerySummaryFunction.Sum); using (var reader = new SqlQueryReader(DataContext, sql)) { reader.Open(); if (reader.Read()) { if (!reader.IsDbNull(0)) { var v = reader.GetValue(0); v.TryParse(out result); } } reader.Close(); } return(result); }