对StartsWith的查询

Question

我必须尝试在搜索的基础上寻找结果，这应该是开始，但我找不到QueryOver，它已经开始，还有其他的方式吗？

public IEnumerable<Company> Find(string keyword)
{
     var sesion = SessionController.CurrentSession;
     return sesion.QueryOver<Company>()
     .Where(
        Restrictions.On<Company>(x => x.CompanyName).IsLike("%" + keyword + "%") ||
        Restrictions.On<Company>(x => x.Id).IsLike("%" + keyword + "%")
     )
     .List<Company>();
}

Answer 1

得到QueryOver基础结构支持的方法是使用显式MatchMode

sesion
  .QueryOver<Company>()
  .Where
  (
     Restrictions.On<Company>(x => x.CompanyName).IsLike(keyword, MatchMode.Start) ||
     Restrictions.On<Company>(x => x.Id         ).IsLike(keyword, MatchMode.Start)
  )
  .List<Company>();

但是，使用非常少的代码( Restrictions.On样式中的自定义扩展)，我们甚至可以实现以下语法：

...
.Where
(
   Restrict.On<Contact>(x => x.CompanyName).StartsWith(keyword) ||
   Restrict.On<Contact>(x => x.Id         ).StartsWith(keyword)
)

以及Restrict的定义

public static class Restrict
{
    public static StringRestrictionBuilder<T> On<T>(Expression<Func<T, object>> expr)
    {
        return new StringRestrictionBuilder<T>(expr);
    }
    public class StringRestrictionBuilder<T>
    {
        readonly Expression<Func<T, object>> _expression;
        public StringRestrictionBuilder(Expression<Func<T, object>> expression)
        {
            _expression = expression;
        }
        public AbstractCriterion StartsWith(string value)
        {
            return Restrictions.On(_expression).IsLike(value, MatchMode.Start);
        }
        public AbstractCriterion Contains(string value)
        {
            return Restrictions.On(_expression).IsLike(value, MatchMode.Anywhere);
        }
        public AbstractCriterion EndsWith(string value)
        {
            return Restrictions.On(_expression).IsLike(value, MatchMode.End);
        }
    }
}