Nhibernate equal criteria

Question

I have a scenario that I have to check the table id list with the given string list and get all the relevant data.I know how to retrieve the data for one equal criteria.

var criteria = sm.Session.CreateCriteria(GetRegisteredType<Data>());

criteria = criteria.Add(Expression.Eq("Id", "9999"));

I have string list that I need to check with Id column. Can anyone help with me this?

Possible duplicate of [nhibernate query using criteria for list of value type](https://stackoverflow.com/questions/28094096/nhibernate-query-using-criteria-for-list-of-value-type) — Frédéric, May 26 '17 at 14:59
You have your answer in above linked question. If you need to do that with a subquery, see [this one](https://stackoverflow.com/q/30242846/1178314). — Frédéric, May 26 '17 at 15:01

score 1 · Answer 1 · answered May 26 '17 at 11:25

Do you need to use an ICriteria-based query? If not, a LINQ-based query would look something like:

var results = 
    sm.Session
        .Query<Data>()
        .Where(d => listOfStrings.Contains(d.Id))
        .ToList();

However, you'll need to be wary of the size of your string list, as they will be passed as parameters and will be subject to a limit.

score 1 · Accepted Answer · answered May 26 '17 at 15:34

Let's assume you have the list:

var list = new string[] { "9999", "1111" };

Criteria

Session.CreateCriteria(GetRegisteredType<Data>()).Add(Restrictions.InG("Id", list));

QueryOver

Session.QueryOver<Data>().Where(x => x.Id.IsIn(list));

NHibernate.LINQ

Session.Query<Data>().Where(x => list.Contains(x.Id))

Nhibernate equal criteria

2 Answers2