Please add some "in clause" examples to your docs

[Nefcanto]

I'm trying to create an in clause query using dynamic linq. I tried:

dbSet<T>.AsQueryable().Where($"Key in @0", keys);

And I got this error:

An exception of type 'System.InvalidOperationException' occurred in System.Linq.Expressions.dll but was not handled in user code: 'No generic method 'Contains' on type 'System.Linq.Enumerable' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic. '

I tried:

dbSet<T>.AsQueryable().Where($"Key.In(@0)", keys);

And I got the same error. Please note that values is an array of keys:

var values = new string[] { "pump", "motor" };

Then I tried:

dbSet<T>.AsQueryable().Where($"@0.Contains(Key)", keys);

No exception, but I got this translation, which is wrong:

AND (h.Key IS NOT NULL AND ((LOCATE(h.Key, 'pump') > 0) OR (h.Key LIKE '')))

Unfortunately, your documentation does not have examples related to how to generate the in clause. And these erroneous codes are proposed by AI (ChatGPT and Gemini).

I did not create an MRE (minimally reproducible example) because it's all about docs. Please add some examples to the docs. Thank you.