public override void Build(DbCommandBuilder builder, IServiceProvider serviceProvider)
{
builder.SqlBuilder.Write("json_build_object(");
builder.SqlBuilder.WriteLine();
++builder.SqlBuilder.Indent;
var membersList = members.ToList();
for (var i = 0; i < membersList.Count; ++i)
{
var member = membersList[i];
var parameter = builder.AddParameter(member.Key);
builder.SqlBuilder.Write(parameter.ParameterName);
builder.SqlBuilder.Write(", ");
member.Value.Build(builder, serviceProvider);
if (i < membersList.Count - 1)
{
builder.SqlBuilder.WriteLine(", ");
}
}
--builder.SqlBuilder.Indent;
builder.SqlBuilder.WriteLine();
builder.SqlBuilder.Write(")");
}
public void Build(DbCommandBuilder builder, IServiceProvider serviceProvider)
{
builder.SqlBuilder.Write(sql);
foreach (var parameter in parameters)
{
var p = builder.AddParameter(parameter.Value);
p.ParameterName = parameter.Key;
}
}
public void Build(DbCommandBuilder builder, IServiceProvider serviceProvider)
{
var parameter = builder.AddParameter(Value);
builder.SqlBuilder.Write(parameter.ParameterName);
}