The SQL query generation for Contains() is very bad for large arrays (it is actually much slower than the query itself). The problem is described here:

https://entityframework.codeplex.com/workitem/245

Entity Framework 6.0 added support for explicit generation of DbInExpression. But as SQLite EF provider does not handle DbInExpression, the feature is not used. Instead, an OR-subtree is back-translated to IN again.

Would it be possible to add proper support for DbInExpression to reduce the query generation time? It should not be too difficult (as far as I can see). 

Thank you.