Limitations nHibernate contains

Question

I have an expression to evaluate as below

Restrictions.In (criteriaItem.PropertyName, criteriaItem.FilterValues);

Restrictions.Like (criteriaItem.PropertyName, criteriaItem.FilterValues);

I want Contains how to do this?

Answer 1

string.Contains will display like in sql, just with the addition of wildcards. Try:

Restrictions.Like(criteriaItem.PropertyName,"%" + criteriaItem.ContainsValue + "%");