public static void AppendKeyValuePairs(StringBuilder sb, List <KeyValuePair <string, object> > pairs, string connector) { for (int index = 0; index < pairs.Count; ++index) { KeyValuePair <string, object> pair = pairs[index]; sb.Append( DatabaseUtil.Dialect.QuoteForColumnName(pair.Key) + " = " + SqlUtil.GetValueString(pair.Value)); if (index < pairs.Count - 1) { sb.Append(connector); } } }
public static string BuildInsert(KeyValueListBase liste) { List <KeyValuePair <string, object> > pairs = liste.Pairs; int count = pairs.Count; StringBuilder stringBuilder = SqlUtil.PrepareInsertBuilder(liste); stringBuilder.Append("("); for (int index = 0; index < count; ++index) { KeyValuePair <string, object> keyValuePair = pairs[index]; stringBuilder.Append(SqlUtil.GetValueString(keyValuePair.Value)); if (index < count - 1) { stringBuilder.Append(","); } } stringBuilder.Append(")"); return(stringBuilder.ToString()); }