public Task <long> GetCountAsync <TEntity>(TEntity entity) where TEntity : ITableDto { var query = queryFactory.GetCountQuery <TEntity>(); logger.LogDebug("GetCountAsync query:{query} entity:{@entity}", query, entity); return(uk.DbConnection.ExecuteScalarAsync <long>(query, entity, uk.DbTransaction)); }
public long GetCount <TEntity>(TEntity entity) where TEntity : class { var query = queryFactory.GetCountQuery <TEntity>(); // logger.LogDebug("GetCountAsync query:{query} entity:{@entity}", query, entity); return(Conn.ExecuteScalar <long>(query, entity, Tran)); }
public async Task <long> GetCountAsync() { // var sql = $"SELECT count(*) " + // $"FROM {ProcessHistoryDto.TableName} "; var tableName = tableQuery.GetTable <ProcessHistoryDto>().Name; var sql = $"SELECT count(*) FROM {tableName}"; sql = tableQuery.GetCountQuery <ProcessHistoryDto>(); var count = await DbConnection.ExecuteScalarAsync <long>(sql, DbTransaction); return(count); }