nhibernate query using criteria for list of value type

Question

Class contains List of int: ICollection<int> CategoryEnum

How I can create a query criteria for that?

I tried:

List<int> postedCategories = new List<int>{ 1 };
int category = 0;

q.JoinAlias(p => p.CategoryEnum, () => category)
 .AndRestrictionOn(x => category)
   .IsIn(postedCategories);

but I get a sql query WHERE 0 in (1)

I don't have a problem for collecion of object, it works but it doesn't work for collection of int.

This is part of my mapping:

<set name="CategoryEnum" table="CategoriesEnum">
  <key column="Id"></key>
  <element column="CategoryId" type="int"></element>
</set>

Community · Accepted Answer · 2017-05-23 11:56:59Z

1

Check these Q & A:

You will find, that we can access element with a keyword ".elements"

Restrictions.In("category.elements", postedCategories)

with query over:

q.JoinAlias(p => p.CategoryEnum, () => category)
 .Where(Restrictions.In("category.elements", postedCategories))

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Jan 22, 2015 at 17:31

Radim Köhler

124k48 gold badges243 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

nhibernate query using criteria for list of value type

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related