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());
}
}
