使用C#在CosmosDB中查询SQL

using Microsoft.Azure.Cosmos;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

public class Program
{
    private static readonly string EndpointUrl = "your-cosmosdb-endpoint-url";
    private static readonly string AuthorizationKey = "your-cosmosdb-authorization-key";
    private static readonly string DatabaseId = "your-database-id";
    private static readonly string ContainerId = "your-container-id";

    public static async Task Main(string[] args)
    {
        using (var client = new CosmosClient(EndpointUrl, AuthorizationKey))
        {
            var database = client.GetDatabase(DatabaseId);
            var container = database.GetContainer(ContainerId);

            var sqlQueryText = "SELECT * FROM c WHERE c.id = @id";
            var queryDefinition = new QueryDefinition(sqlQueryText).WithParameter("@id", "your-document-id");

            var queryResultSetIterator = container.GetItemQueryIterator<dynamic>(queryDefinition);
            var results = new List<dynamic>();

            while (queryResultSetIterator.HasMoreResults)
            {
                var response = await queryResultSetIterator.ReadNextAsync();
                results.AddRange(response);
            }

            foreach (var result in results)
            {
                Console.WriteLine(result);
            }
        }
    }
}

SELECT [TOP <number>] [VALUE] <projection>
FROM <collection>
[WHERE <filter>]
[ORDER BY <property> [ASC|DESC]]
[OFFSET <number> LIMIT <number>]

SELECT * FROM c

SELECT * FROM c WHERE c.property = value

SELECT * FROM c WHERE c.property = value ORDER BY c.property DESC

SELECT TOP 10 * FROM c WHERE c.property = value