cosmos db get all items C# code example

Example: cosmos db get all items in container

//These three are from microsoft.azure.cosmos
//You can download them using nuget
CosmosClient cosmosClient = new CosmosClient(Uri, PrimaryKey);
Database database = cosmosClient.GetDatabase(DatabaseId);
Container container = database.GetContainer(ContainerId);

string sqlQueryText = "SELECT * FROM c";

QueryDefinition definition = new QueryDefinition(sqlQueryText);

/*
Note that your Test object must have the same properties that
are stored in your database

	public class Test
    {

	[JsonProperty(PropertyName = "<your property name>")]
	public string property { get; set; }
    }
*/

var iterator = container.GetItemQueryIterator<Test>(definition);

while (iterator.HasMoreResults)
{
	FeedResponse<Test> result = await iterator.ReadNextAsync();
	foreach (var item in result)
    {
		Console.Writeline(item.property);
    }
}