public async Task <SdkClientResult <T> > ExecSprocAsync <T>(string databaseId, string collectionId, string sprocName, string documentId, string partitionKey)
{
SdkClientResult <T> result = new SdkClientResult <T>();
// Local proxy objects
Database database = this.CosmosClient.GetDatabase(databaseId);
Container container = database.GetContainer(collectionId);
// Enable sproc logging which we set to the result below - this is not enabled by default
StoredProcedureRequestOptions sprocRequestOptions = new StoredProcedureRequestOptions()
{
EnableScriptLogging = true
};
StoredProcedureExecuteResponse <string> response = await container.Scripts.ExecuteStoredProcedureAsync <string>
(
sprocName,
new PartitionKey(partitionKey),
new[] { documentId },
sprocRequestOptions
);
result.Content = JsonConvert.DeserializeObject <T>(response.Resource);
result.RequestInfo.RequestCharge = response.RequestCharge;
result.RequestInfo.Logging = response.ScriptLog;
return(result);
}
public async Task <SdkClientResult <List <T> > > QueryAsync <T>(string databaseId, string collectionId, string query)
{
SdkClientResult <List <T> > result = new SdkClientResult <List <T> >();
QueryDefinition queryDefinition = new QueryDefinition(query);
QueryRequestOptions queryRequestOptions = new QueryRequestOptions()
{
MaxBufferedItemCount = -1,
MaxConcurrency = -1,
MaxItemCount = 100
};
// Local proxy objects
Database database = this.CosmosClient.GetDatabase(databaseId);
Container container = database.GetContainer(collectionId);
List <T> documents = new List <T>();
using (var resultsIterator = container.GetItemQueryIterator <T>(queryDefinition, requestOptions: queryRequestOptions))
{
while (resultsIterator.HasMoreResults)
{
FeedResponse <T> currentResultSet = await resultsIterator.ReadNextAsync();
documents.AddRange(currentResultSet.Resource);
result.RequestInfo.RequestCharge += currentResultSet.RequestCharge;
}
}
result.Content = documents;
return(result);
}
public async Task <SdkClientResult> ListDocumentsAsync(string databaseId, string collectionId)
{
SdkClientResult result = new SdkClientResult();
// Local proxy objects
Database database = this.CosmosClient.GetDatabase(databaseId);
Container container = database.GetContainer(collectionId);
List <object> documents = new List <object>();
using (var resultsIterator = container.GetItemQueryIterator <object>())
{
while (resultsIterator.HasMoreResults)
{
FeedResponse <object> currentResultSet = await resultsIterator.ReadNextAsync();
documents.AddRange(currentResultSet.Resource);
result.RequestInfo.RequestCharge += currentResultSet.RequestCharge;
}
}
result.Content = documents;
return(result);
}
public async Task <SdkClientResult> GetDatabaseAsync(string databaseId)
{
SdkClientResult result = new SdkClientResult();
// Local proxy object
Database database = this.CosmosClient.GetDatabase(databaseId);
DatabaseResponse response = await database.ReadAsync();
result.Content = response.Resource;
result.RequestInfo.RequestCharge = response.RequestCharge;
return(result);
}
public async Task <SdkClientResult <T> > UpsertAsync <T>(string databaseId, string collectionId, T item, string partitionKey)
{
SdkClientResult <T> result = new SdkClientResult <T>();
// Local proxy objects
Database database = this.CosmosClient.GetDatabase(databaseId);
Container container = database.GetContainer(collectionId);
ItemResponse <T> response = await container.UpsertItemAsync <T>(item, new PartitionKey(partitionKey));
result.Content = response.Resource;
result.RequestInfo.RequestCharge = response.RequestCharge;
return(result);
}
public async Task <SdkClientResult> GetCollectionAsync(string databaseId, string collectionId)
{
SdkClientResult result = new SdkClientResult();
// Local proxy objects
Database database = this.CosmosClient.GetDatabase(databaseId);
Container container = database.GetContainer(collectionId);
ContainerResponse response = await container.ReadContainerAsync();
result.Content = response.Resource;
result.RequestInfo.RequestCharge = response.RequestCharge;
return(result);
}
public async Task <SdkClientResult> ListDatabasesAsync()
{
SdkClientResult result = new SdkClientResult();
List <DatabaseProperties> databases = new List <DatabaseProperties>();
using (var resultsIterator = this.CosmosClient.GetDatabaseQueryIterator <DatabaseProperties>())
{
while (resultsIterator.HasMoreResults)
{
FeedResponse <DatabaseProperties> currentResultSet = await resultsIterator.ReadNextAsync();
databases.AddRange(currentResultSet.Resource);
result.RequestInfo.RequestCharge += currentResultSet.RequestCharge;
}
}
result.Content = databases;
return(result);
}
public async Task <SdkClientResult> ListCollectionsAsync(string databaseId)
{
SdkClientResult result = new SdkClientResult();
// Local proxy object
var database = this.CosmosClient.GetDatabase(databaseId);
List <ContainerProperties> containers = new List <ContainerProperties>();
using (var resultsIterator = database.GetContainerQueryIterator <ContainerProperties>())
{
while (resultsIterator.HasMoreResults)
{
FeedResponse <ContainerProperties> currentResultSet = await resultsIterator.ReadNextAsync();
containers.AddRange(currentResultSet.Resource);
result.RequestInfo.RequestCharge += currentResultSet.RequestCharge;
}
}
result.Content = containers;
return(result);
}
