title: Querying multiple items in Azure Cosmos Db
body: <p>Suppose I have a "Employee" container with Partition Key as the "EmployeeId". What is the best way to query multiple employee items from this data store? I am using the .Net SDK V3 of Azure Cosmos Db</p>
  
  <p>The option I could think of is - </p>
  
  <p>Using ARRAY_CONTAINS() - <a href="https://stackoverflow.com/questions/58633950/enable-query-across-partitions-on-microsoft-azure-cosmos-client">link</a></p>
  
  <pre><code>Select * FROM Employee e where ARRAY_CONTAINS(@EmployeesIdList, e.EmployeeId)
  </code></pre>
  
  <p>This query will still be a cross-partitioned query. 
  Also as per <a href="https://stackoverflow.com/questions/58633950/enable-query-across-partitions-on-microsoft-azure-cosmos-client">this</a>, cross partition queries are enabled by default in the V3 sdk. So is this the correct way to query multiple such items?</p>