public async Task <TEntity> InsertAsync(IStorageDbConnection conn, TEntity entityToInsert, IEnumerable <Expression <Func <TEntity, object> > > ignoredFields, AutoIncrementTransformer <TKey, TEntity> atf, IDbTransaction tr, CancellationToken cancellationToken)
{
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
if (entityToInsert == null)
{
throw new ArgumentNullException(nameof(entityToInsert));
}
var result = ConstructInsertSql(entityToInsert, ignoredFields, atf != null);
conn.TextWriter.WriteSql(result.CommandText);
var cmd = CreateDapperCmd(result.CommandText, result.Parameters, tr, cancellationToken);
if (atf == null)
{
await conn.ExecuteAsync(cmd);
}
else
{
var id = (TKey)Convert.ChangeType(await conn.QuerySingleAsync(typeof(TKey), cmd), typeof(TKey), CultureInfo.InvariantCulture);
atf(id, entityToInsert);
}
return(entityToInsert);
}
public async Task <long> CountAsync(IStorageDbConnection conn, Expression <Func <TEntity, object> > member, WhereClauseResult whereClause, IDbTransaction tr, CancellationToken cancellationToken)
{
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
var result = ConstructCountSql(member, whereClause);
conn.TextWriter.WriteSql(result.CommandText);
var cmd = CreateDapperCmd(result.CommandText, result.Parameters, tr, cancellationToken);
return((long)Convert.ChangeType(await conn.QuerySingleAsync(typeof(long), cmd), typeof(long), CultureInfo.InvariantCulture));
}
public async Task <bool> ExistsAsync(IStorageDbConnection conn, WhereClauseResult whereClause, IDbTransaction tr, CancellationToken cancellationToken)
{
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
var result = ConstructExistsSql(whereClause);
conn.TextWriter.WriteSql(result.CommandText);
var cmd = CreateDapperCmd(result.CommandText, result.Parameters, tr, cancellationToken);
return((bool)Convert.ChangeType(await conn.QuerySingleAsync(typeof(int), cmd), typeof(bool), CultureInfo.InvariantCulture));
}