Logical AND for LINQ to CosmosDb Sql API

Question

I am trying to AND multiple LINQ (rather lambda) Expressions into a where clause to query a local CosmosDb emulator.

The resulting query looks like this:

SELECT * FROM root 
WHERE ((root["ActivityName"] IN ("Run")) & (root["CreatedByUser"]["Id"] IN (10023))) 
ORDER BY root["CreatedOnUtc"] DESC

Note the bitwise & operator in the query. This leads to no results as the outcome despite of the fact that matching results actually exist in the CosmosDb.

When I run this query, I get the results

SELECT * FROM root 
WHERE ((root["ActivityName"] IN ("Run")) AND (root["CreatedByUser"]["Id"] IN (10023))) 
ORDER BY root["CreatedOnUtc"] DESC

The code that I am using to combine multiple lambda expressions is roughly:

Expression.And(first, second);

details for it can be found here:

How do I combine my Expressions to yield a query with logical AND instead of bit-wise &?

&& -> Expression.AndAlso, || -> Expression.OrElse

Ivan Stoev
– Ivan Stoev

2018-07-07 21:21:29 +00:00
Commented Jul 7, 2018 at 21:21 — Ivan Stoev
– Ivan Stoev, Commented Jul 7, 2018 at 21:21

Nick Chapsas · Accepted Answer · 2018-07-07 23:59:45Z

1

Expression.AndAlso(first, second); is what you need.

As you said, Expression.And represents a bitwise AND operation while Expression.AndAlso represents a conditional (what you called logical) AND operation.

edited Jul 7, 2018 at 23:59

answered Jul 7, 2018 at 21:24

Nick Chapsas

7,2501 gold badge22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Logical AND for LINQ to CosmosDb Sql API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related