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