public PostgresInsertValuesCommand(IServiceProvider serviceProvider, PostgresInsertValuesCommand <TColumns> command, Expression <Func <TResult> > expression)
: base(serviceProvider, ((IWrapper <InsertClause <TColumns> >)command).Value, ((IWrapper <OnConflictClause>)command).Value)
{
returningClause = serviceProvider.GetRequiredService <PostgresReturningClause <TResult> >();
returningClause.Expression = expression;
valuesClause = ((IWrapper <ValuesClause <TColumns> >)command).Value;
}
public ToDBCommand Values(params string[] parameters)
{
if (parameters == null || parameters.Length == 0)
{
throw new ToDBException("No parameters passed");
}
ValuesClause.Add(new Model.Values {
Parameters = parameters
});
return(this);
}
protected virtual void ParseValues(ValuesClause values)
{
builder.Append("VALUES");
foreach (var tuple in values.ValuesList)
{
builder.Append('(');
for (int i = 0; i < tuple.Length; i++)
{
if (i > 0)
{
builder.Append(", ");
}
builder.AppendValue(tuple[i]);
}
builder.Append(')');
}
}
public SqlServerInsertValuesCommand(IServiceProvider serviceProvider, SqlServerInsertValuesCommand <TColumns> command)
: base(serviceProvider, ((IWrapper <InsertClause <TColumns> >)command).Value, ((IWrapper <OnConflictClause>)command).Value)
{
SqlServerOutputClause = serviceProvider.GetRequiredService <SqlServerOutputClause <TResult> >();
valuesClause = command.ValuesClause;
}
public InsertQueryBuilder WithValues(ValuesClause values)
{
Values = values;
return(this);
}
public PostgresInsertValuesCommand(IServiceProvider serviceProvider, Table table, T expression)
: base(serviceProvider, table, expression)
{
valuesClause = serviceProvider.GetRequiredService <ValuesClause <T> >();
}
public ICommand Values(params object[] values)
{
Clauses.Add(ValuesClause.Create(values));
return(this);
}
