[BUG] LINQ !Contains returns no result

[MuhKuh7]

Version
5.0.5

Describe the bug
The negated LINQ contains does not work

Code to Reproduce
This should get me all my objects where StringList does not contain myString
results = results.Where(x => !x.StringList.Contains(myString));
The resulting collection is empty however.

A workaround is:
results = results.Where(x => x.StringList.All(t => t != myString));

[ajmal-ahmed]

this usually happens with LINQ query in LiteDB when you does not assign any value for a field it's considered as null (which in turn is a separate data type) and when you query that field you have to avoid those records.
As of now you might see your code first might work as
results = results.Where(x => (x.StringList!=null)&&(!x.StringList.Contains(myString)));

[lbnascimento]

@MuhKuh7 This issue is fixed in master and its fix will be present in the next incremental release.

[MuhKuh7]

Tested and works.
Thx for the fast fix!