public List <T> ScalarListResultSync <T>(BaseInsertQuery query, DbConnection con, DbTransaction tx, bool prepare = true) { using (var cmd = ToCommand(query, con, tx)) { return(ScalarListResultSync <T>(cmd, prepare)); } }
public BaseInsertQuery EndValues() { var q = _query; _query = null; return(q.WithValues(this)); }
public async Task <T> ScalarResult <T>(BaseInsertQuery query, DbConnection con, DbTransaction tx, bool prepare = true) { using (var cmd = ToCommand(query, con, tx)) { return(await ScalarResult <T>(cmd, prepare)); } }
public void InsertSync <T>(T[] items, DbConnection con, DbTransaction tx = null) { var table = TypeToTableEntry <T> .DefaultTable; var q = new BaseInsertQuery(table).WithValues(items.Select((item, i) => TypeToTableEntry <T> .ToValues(item, table, i)).ToArray()); var returningParts = TypeToTableEntry <T> .Returning(items[0], table); if (returningParts != null) { q = q.Returning(returningParts); var ids = q.ScalarListSync <int>(con, tx, items.Length == 1); if (ids.Count != items.Length) { throw new InvalidOperationException(); } for (int i = 0; i < items.Length; i++) { TypeToTableEntry <T> .ApplyReturning(items[i], ids[i]); } } else { q.ExecuteSync(con, tx, items.Length == 1); } }
public async Task <List <T> > ScalarListResult <T>(BaseInsertQuery query, DbConnection con, DbTransaction tx) { using (var cmd = ToCommand(query, con, tx)) { return(await ScalarListResult <T>(cmd)); } }
public T ScalarResultSync <T>(BaseInsertQuery query, DbConnection con, DbTransaction tx) { using (var cmd = ToCommand(query, con, tx)) { return(ScalarResultSync <T>(cmd)); } }
protected ValuesCollection(BaseInsertQuery query, List <SetFieldPart> values) { _query = query; Values = values; }
public DbCommand ToCommand(BaseInsertQuery query, DbConnection con, DbTransaction tx = null) => ToCommand <InsertVisitor, BaseInsertQuery>(query, con, tx);
public string ToQueryText(BaseInsertQuery query) => ToQueryText <InsertVisitor, BaseInsertQuery>(query);