LINQ Query Issue with using Any on DocumentDB for child collection

Question

Using v1.8 .Net SDK

Trying return Sales where the Sale client array contains the Client ID I’m looking for.

Sales.Where(sale => sale.Clients.Any(c => c.ClientId == clientID));

Returns Error "Nullable object must have a value."

at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions) at System.Threading.Tasks.Task1.GetResultCore(Boolean waitCompletionNotification) at System.Threading.Tasks.Task1.get_Result() at Microsoft.Azure.Documents.Linq.DocumentQuery1.GetEnumerator() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)

ClientID is a GUID, but trying to query any property on the client object returns the same error.

If I run the same query on the same data but just using a List collection (i.e. not using DocumentDB) then all is fine.

Any advice appreciated. Thanks

DocumentDB does not support ANY - see https://feedback.azure.com/forums/263030-documentdb/suggestions/11503872-support-linq-any-or-where-for-child-object-collect — Chris Small, Jul 11 '16 at 14:53

score 12 · Accepted Answer · answered Aug 11 '16 at 06:01

12

This query can be alternatively expessed using SelectMany + Where:

Sales.SelectMany(s => s.Clients.Where(c => c.ClientID == clientID).Select(c => s));

answered Aug 11 '16 at 06:01

Aravind Krishna R.

7,885
27
37

Just out of curiousity, how would you write something like this in the document DB sql syntax? – Michiel Cornille Dec 07 '16 at 16:55
1

Very similar because both DocumentDB SQL and LINQ work over objects: SELECT sale FROM sale JOIN client IN sale.clients WHERE client.clientId = "c" – Aravind Krishna R. Dec 08 '16 at 03:07
Excellent, great work. I never considered c => s before to get back to the "outer" entity. Thanks. – SimonGoldstone Sep 21 '18 at 07:45
Is this possible using the from..select..where Linq syntax? – SimonGoldstone Sep 21 '18 at 07:46

LINQ Query Issue with using Any on DocumentDB for child collection

1 Answers1

Linked