public void StoreCacheDetailInTable(string cahceName, string feedName, string cacheServiceName) { try { string connStr = CloudConfigurationManager.GetSetting("StorageConnectionString"); CloudStorageAccount storageAccount = CloudStorageAccount.Parse(connStr); CloudTableClient client = storageAccount.CreateCloudTableClient(); CloudTable table = client.GetTableReference("cs218cache"); // table.CreateIfNotExists(); CS218CacheTable cacheTable = new CS218CacheTable(); cacheTable.Id = Guid.NewGuid().ToString(); cacheTable.CacheName = cahceName; cacheTable.FeedName = feedName; cacheTable.CacheServiceName = cacheServiceName; cacheTable.PartitionKey = cahceName; cacheTable.RowKey = feedName; cacheTable.CreatedDate = DateTime.Now; cacheTable.LastFetchDate = DateTime.Now; cacheTable.FetchCount = 0; TableOperation insertOperation = TableOperation.Insert(cacheTable); table.Execute(insertOperation); } catch (Exception exp) { Trace.TraceError(exp.Message + Environment.NewLine + exp.StackTrace); } }
private void UpdateFeedCacheItem(string cachename, string FeedName) { string connStr = CloudConfigurationManager.GetSetting("StorageConnectionString"); CloudStorageAccount storageAccount = CloudStorageAccount.Parse(connStr); CloudTableClient client = storageAccount.CreateCloudTableClient(); CloudTable table = client.GetTableReference("cs218cache"); TableOperation retrieveOperation = TableOperation.Retrieve <CS218CacheTable>(cachename, FeedName); TableResult retrievedResult = table.Execute(retrieveOperation); CS218CacheTable updateEntity = (CS218CacheTable)retrievedResult.Result; updateEntity.FetchCount = updateEntity.FetchCount + 1; updateEntity.LastFetchDate = DateTime.Now; TableOperation insertOrReplaceOperation = TableOperation.InsertOrReplace(updateEntity); table.Execute(insertOrReplaceOperation); }