public static string BuildWhere(List <KeyValuePair <string, object> > pairs)
{
StringBuilder sb = new StringBuilder();
SqlUtil.AppendKeyValuePairs(sb, pairs, " AND ");
return(sb.ToString());
}
public static string BuildUpdate(KeyValueListBase liste, string where)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE " + liste.TableName + " SET ");
SqlUtil.AppendKeyValuePairs(sb, liste.Pairs, ", ");
sb.Append(" WHERE ");
sb.Append(where);
return(sb.ToString());
}