DocumentDB IN keyword with Linq

930 views Asked by At

You can now create IN queries with DocumentDB like this:

SELECT *
FROM Families 
WHERE Families.id IN ('AndersenFamily', 'WakefieldFamily')

But if I run a similar query with Linq I get an error {"Method 'Contains' is not supported."}

.where(a => familyNames.Contains(a.Families))

How can I crate IN queries with Linq?

2

There are 2 answers

0
Andrew Liu On BEST ANSWER

IN is not currently supported by the LINQ provider.

We will fix this in a future SDK update.

0
Mohamed On

This is fixed now, what you have should work with the new SDK releases.