static List <TestEntity> GetTableEntitiesWithTableQuery() { /* * CloudStorageAccount * CloudTableClient * CloudTable * TableOperation * TableQuery */ _____________ account = _____________.Parse(_connectionString); _____________ client = account.CreateCloudTableClient(); _____________ table = client.GetTableReference("test"); _____________ <TestEntity> query = new _____________ <TestEntity>() .Where( TableQuery.CombineFilters( TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Partition1"), TableOperators.And, TableQuery.GenerateFilterCondition("prop1", QueryComparisons.Equal, "even"))) .Take(3); var results = new List <TestEntity>(); TableContinuationToken continuationToken = null; //do //{ var queryResults = table.ExecuteQuerySegmentedAsync(query, continuationToken).Result; results.AddRange(queryResults.Results); continuationToken = queryResults.ContinuationToken; //} while (continuationToken != null); return(results); }
static void SaveTableEntity() { /* * CloudStorageAccount * CloudTableClient * CloudTable * TableBatchOperation * TableOperation */ _____________ account = _____________.Parse(_connectionString); _____________ client = account.CreateCloudTableClient(); _____________ table = client.GetTableReference("test"); table.CreateIfNotExistsAsync().Wait(); var entity = new TestEntity() { prop1 = "even" }; _pk = entity.PartitionKey; _rk = entity.RowKey; _____________ insertOperation = _____________.Insert(entity); table.ExecuteAsync(insertOperation).Wait(); }
static void SaveTableEntityBatch() { /* * CloudStorageAccount * CloudTableClient * CloudTable * TableBatchOperation * TableOperation */ _____________ account = _____________.Parse(_connectionString); _____________ client = account.CreateCloudTableClient(); _____________ table = client.GetTableReference("test"); _____________ insertBatchOperation = new _____________(); for (int i = 0; i < 10; i++) { insertBatchOperation.Insert(new TestEntity() { prop1 = i % 2 == 0 ? "even" : "odd" }); Thread.Sleep(1); } table.ExecuteBatchAsync(insertBatchOperation).Wait(); }
static TestEntity GetTableEntityByPkRk() { /* * CloudStorageAccount * CloudTableClient * CloudTable * TableOperation * TableQuery */ _____________ account = _____________.Parse(_connectionString); _____________ client = account.CreateCloudTableClient(); _____________ table = client.GetTableReference("test"); _____________ retrieveOperation = _____________.Retrieve <TestEntity>(_pk, _rk); var result = table.ExecuteAsync(retrieveOperation).Result.Result as TestEntity; return(result); }