如何在 Dapper 扩展中编写'Not Equal'子句？

Question

我想在dapper扩展中创建以下SQL查询。

SELECT DISTINCT Description FROM tblPeople WHERE ID = 2 AND
(AddressTown IS NOT NULL AND AddressTown<>'') ORDER BY Description ;

我已经试过了:

PredicateGroup pgMain = new PredicateGroup 
{ Operator = GroupOperator.And, Predicates = new List<IPredicate>() };
pgMain.Predicates.Add(Predicates.Field<tblPeople >(f => f.ID, Operator.Eq, 2));  
var peopleList = connection.GetList<tblPeople>(pgMain);

Answer 1

您可以使用最后bool not参数。可选参数，默认值为false。

所以，你的新代码应该如下所示:

pgMain.Predicates.Add(Predicates.Field<tblPeople>(f => f.ID, Operator.Eq, 2, true));

观察上面代码中最后一个参数的值true

详情请参考答案