private static void AppendInsertValuesSql(StringBuilder sql, Dictionary <string, object> parameters, List <ColumnDefinition> columns, JObject item)
{
sql.Append("(");
int colCount = 0;
foreach (var column in columns)
{
if (colCount > 0)
{
sql.Append(",");
}
JToken rawValue = item.GetValue(column.Name, StringComparison.OrdinalIgnoreCase);
object value = SqlHelpers.SerializeValue(rawValue, column.StoreType, column.JsonType);
//The paramname for this field must be unique within this statement
string paramName = "@p" + parameters.Count;
sql.Append(paramName);
parameters[paramName] = value;
colCount++;
}
sql.Append(")");
}
private string CreateParameter(object value)
{
int paramNumber = this.Parameters.Count + 1;
string paramName = "@p" + paramNumber;
this.Parameters.Add(paramName, SqlHelpers.SerializeValue(new JValue(value), allowNull: true));
return(paramName);
}
