private static string ToSqlClause(KeyValuePair <string, object>[] conditions)
{
if (conditions == null)
{
return(string.Empty);
}
StringBuilder sb = new StringBuilder();
for (int i = 0; i < conditions.Length; i++)
{
string op = (conditions[i].Value == null || conditions[i].Value is DBNull)?" IS ":"=";
sb.Append(string.Format("{0}{1}{2}",
SqlFormat.EscapeSql(conditions[i].Key), op,
SqlFormat.ToSqlValueString(conditions[i].Value)));
if (i != conditions.Length - 1)
{
sb.Append(" AND ");
}
}
return(sb.ToString());
}