anonymous added on 2015-04-19 18:03:20:
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:
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).