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