nhibernate CreateCriteria 通配符 就像当

Question

在 SQL 中我可以写

SELECT blah FROM Clients
Where @p1 Like '%'+lastname+'%'

如何在 Nhibernate 中使用 CreateCriteria 来表示这一点？

我已经尝试过s.CreateCriteria<Client>.Add(Restrictions.Where<Client>(c => "something".Contains(c.LastName))

但出现错误

System.Exception: Unrecognised method call: System.String:Boolean Contains(System.String)\r\n at NHibernate.Impl.ExpressionProcessor.ProcessCustomMethodCall(MethodCallExpression methodCallExpression)

我也尝试过

s.CreateCriteria<Client>.Add(Restrictions.Where<Client>(c => "something".IndexOf(c.LastName) != -1))

但是得到

"variable 'c' of type 'TrinityFinance.Data.Entities.Client' referenced from scope '', but it is not defined"

请注意，此处的顺序很重要。

@p1 Like '%'+lastname+'%'

与

不同

lastname Like '%'+@p1+'%'

Answer 1

s.CreateCriteria<Client>().Add(
      Restrictions.InsensitiveLike( "LastName", "something", MatchMode.Anywhere))