Azure Cosmos DB: Paging with TOP and new LINQ operators

Azure Updates

Discussionpowered by zap.ms

Published

Dec 14, 2015

Timeline

  • December 2015
    General Availability

Product

Azure Cosmos DB

Tag

Features

Category

Databases
Internet of Things

Description

The latest Azure Cosmos DB service update contains the following changes:

  • New SQL keywords: TOP for paging and limiting results from a query
  • Limit increases: Up to 20 ORs and 200 items within IN expressions are supported per query
  • Performance improvements: The query engine now has faster filtered sort queries, better index plan optimization and improved incremental processing of queries with large result sets

The 1.5.2 release of the .NET SDK contains the following changes:

  • New LINQ operators: Take(), CompareTo(), conditional, and coalesce operators

To learn more, you can: