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
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"));
Thanks - Not sure how I missed that.