hibernate SELECT..WHERE.. IN (value1, val2...)

Question

when using createCriteria, how to specify SELECT..WHERE.. IN (value1, val2...) ?

Answer 1

You could use Restrictions.in method.

Answer 2

See Restrictions.in:

List cats = sess.createCriteria(Cat.class)
    .add( Restrictions.in( "name", new String[] { "Fritz", "Izi", "Pk" } ) )

Answer 3

What if the Restrictions.in should be used on a list eg:

public class MainEntity
{
   public virtual int ID { get;set;}
   public virtual string Name { get;set;}
   public virtual IList<SubEntity> SubEntitys { get;set;}

  public MainEntity() { SubEntitys = new List<SubEntity>(); }
}

public class SubEntity
{
   public virtual int ID { get;set;}
   public virtual string Name { get;set;}
}

How can you make
List mainEntitys= sess.createCriteria(mainEntitys.class)    
.add( Restrictions.in( "SubEntity", List<SubEntity>)