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