DbExtensions -添加带有多个OR子句的Where子句

Question

DbExtensions新手(就在今天早上)，现在我有了一个如下所示的SQL语句

SELECT * FROM myTable
WHERE (Field1 LIKE @Word)
    OR (Field2 LIKE @Word)
    OR (Field3 LIKE @Word)
    OR (Field4 LIKE @Word)
    OR (Field5 LIKE @Word)

我不知道如何使用DbExtensions来做到这一点？

这是我到目前为止所拥有的

var query = SQL
    .FROM("myTable")
    .WHERE();

query.AppendClause("OR", ",", "Field1 LIKE {0}", new string[] { term });
query.AppendClause("OR", ",", "Field2 LIKE {0}", new string[] { term });
query.AppendClause("OR", ",", "Field3 LIKE {0}", new string[] { term });
query.AppendClause("OR", ",", "Field4 LIKE {0}", new string[] { term });
query.AppendClause("OR", ",", "Field5 LIKE {0}", new string[] { term });

但这不会增加很多参数吗，这些参数只有一个值。也许我错过了什么？

Answer 1

var predicate = new StringBuilder();
var parameters = new List<object>();

for (int = 0; i < words.Length; i++) {
   if (i > 0) {
      predicate.Append(" OR ");
   }
   predicate.AppendFormat("({0} LIKE {{{1}}})", GetFieldName(i), i);
   parameters.Add(words[i]);
}

var query = SQL
    .FROM("myTable")
    .WHERE("(" + predicate.ToString() + ")", parameters.ToArray());