Compare a List<string> column with a collection of filter

ServiceStack.OrmLite
1

I want to filter User by a matching Permission List.
I’ve got a
string[] FilterPermission
Then I want to do this
var q = Db.From();
q.where(x=>FilterPermission.Contains(x.Permissions);

It’s a intersection between the 2 list.
Is it possible?

Gianmaria

2

If Permissions is a complex type like string[] or List<string> then it’s blobbed and can’t be queried from server side SQL unless it’s stored in a PostgreSQL complex array type in which case you’ll be able to utilize its Array Functions and Operators.

If Permissions is a string you can use the different IN queries documented from: