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