public virtual int GetCount(object filters) { var sql = SqlSelectGenerator.GetCount(filters); using (var connection = DbConnectionFactory.CreateConnection()) { connection.Open(); return(connection.Query <int>(sql, filters).Single()); } }
public virtual async Task <int> GetCountAsync(object filters) { var sql = SqlSelectGenerator.GetCount(filters); using (var connection = DbConnectionFactory.CreateConnection()) { connection.Open(); var result = await connection.QueryAsync <int>(sql, filters); return(result.Single()); } }