Where IN clause in Ormlite

Hi,

Is there a way to do queries like the below in ormlite

SELECT * FROM table where wid = 1 AND cid IN (1,2,3,4,5,6)

I know how to do it by writing the raw SQL obviously so I m looking for a different way that uses my mappings.

thx
y

Here is the sample from OrmLite documentation how to use IN clause

db.Select<Author>(x => Sql.In(x.City, "London", "Madrid", "Berlin"));
1 Like

Thanks - Not sure how I missed that.