Skip to content

CosmosDb: Optimize into "IN" operator #12635

@smitpatel

Description

@smitpatel
        [ConditionalFact]
        public virtual void Where_logical_or()
        {
            AssertQuery<Customer>(
                cs => cs.Where(c => c.CustomerID == "ALFKI" || c.CustomerID == "ANATR"),
                entryCount: 2);

            AssertSql(
                @"SELECT c AS query
FROM root c
WHERE ((c[""Discriminator""] = ""Customer"") AND ((c[""CustomerID""] = ""ALFKI"") OR (c[""CustomerID""] = ""ANATR"")))");
        }

Can use IN operator to generate better SQL.

Metadata

Metadata

Assignees

No one assigned
    No fields configured for Feature.

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions