以下是使用C#代码示例:
1.创建CosmosClient实例:
var client = new CosmosClient("endpointUri", "primaryKey");
var database = client.GetDatabase("databaseId");
var container = database.GetContainer("containerId");
var query = new QueryDefinition("SELECT * FROM c WHERE c.TransactionDate BETWEEN @startDate AND @endDate")
.WithParameter("@startDate", new DateTimeOffset(startDate).ToUnixTimeMilliseconds())
.WithParameter("@endDate", new DateTimeOffset(endDate).ToUnixTimeMilliseconds());
var iterator = container.GetItemQueryIterator(query);
while (iterator.HasMoreResults)
{
FeedResponse response = await iterator.ReadNextAsync();
foreach (var item in response)
{
Console.WriteLine($"Id:{item.Id}, Name:{item.Name}, Date:{item.TransactionDate}");
}
}
上述步骤将从Cosmos数据库获取具有特定日期范围的数据。