How can I produce this query using NHibernate.Linq?
WHERE this_.Name LIKE @p0; @p0 = 'test' // Notice NO % wild card
Note, this is not Linq To Sql or Entity Framework. This is NHibernate.
Edit:
Here is the desired query using ICriteria:
criteria.Add(Expression.Like("Name", "test"));
return criteria.List<Theater>();
Whilst this has been marked as resolved, which was correct at the time, may I also note that NHibernate has some extensions now so you can do the following:
Session.QueryOver<MyEntity>()
.Where(x => x.Property.IsLike("something", MatchMode.Anywhere))
.List();
This will do a LIKE '%something%'
for you.