Cosmos DB:如何使用LINQ查询检测请求费用

using Microsoft.Azure.Cosmos;
using System;
using System.Linq;

public class Program
{
    private static readonly string endpointUrl = "your_cosmosdb_endpoint_url";
    private static readonly string primaryKey = "your_cosmosdb_primary_key";
    private static readonly string databaseName = "your_database_name";
    private static readonly string containerName = "your_container_name";

    public static async Task Main(string[] args)
    {
        // 创建Cosmos DB客户端实例
        using (CosmosClient client = new CosmosClient(endpointUrl, primaryKey))
        {
            // 连接到目标数据库和容器
            Database database = await client.CreateDatabaseIfNotExistsAsync(databaseName);
            Container container = await database.CreateContainerIfNotExistsAsync(containerName, "/partitionKey");

            // 使用LINQ查询检测请求费用
            IQueryable<dynamic> query = container.GetItemLinqQueryable<dynamic>()
                .Where(item => item.Type == "your_type")
                .OrderBy(item => item.Timestamp)
                .Take(10);

            // 执行查询并获取结果
            FeedIterator<dynamic> iterator = query.ToFeedIterator();
            while (iterator.HasMoreResults)
            {
                FeedResponse<dynamic> response = await iterator.ReadNextAsync();
                double requestCharge = response.RequestCharge;
                Console.WriteLine($"请求费用：{requestCharge}");
            }
        }
    }
}