public Tracker(string accountName, string keyValue) { _applicationId = IdUtil.ApplicationId(); _deviceId = IdUtil.DeviceId(); _anid = IdUtil.GetAnidFromOs(); _appTitle = IdUtil.ApplicationName(); _adsRefreshRate = 3; _pubCenterAdsId = new List<string>(); _adsReady = false; // Due to Disallowed key in RowKey, /, \, #, ? needs to be removed // And excel cannot allow "=" at the beginning foreach (var s in _invalidRowKeyChar) { _deviceId = _deviceId.Replace(s, string.Empty); if (_deviceId.Substring(0, 1) == "=") { _deviceId = "x" + _deviceId; } } GetAdAssemblyVersion(); RefreshIpInfo(); _storageCredentials = new StorageCredentials(accountName, keyValue); _storageAccount = new CloudStorageAccount(_storageCredentials, false); _tableClient = _storageAccount.CreateCloudTableClient(); EnsureTablesCreated(); }
public AuditAzureTableProvider() { try { _account = CloudStorageAccount.Parse(ConfigurationManager.AppSettings["AzureStorageConnectionString"]); _client = _account.CreateCloudTableClient(); } catch (Exception exp) { throw new Exception("Error retreiving reference to Azure Storage Account", exp); } try { _client = _account.CreateCloudTableClient(); } catch (Exception exp) { throw new Exception("Error creating Azure Table Client Object", exp); } try { _vmAuditTable = _client.GetTableReference("VMAudits"); } catch (Exception exp) { throw new Exception("Error retreiving reference to Azure Table Object", exp); } }
protected override void OnLoad() { base.OnLoad(); var accountName = RouteVariables["account"]; var tableName = RouteVariables["table"]; var accountInfo = (from account in StorageAccountInfo.Load() where account.AccountName == accountName select account).FirstOrDefault(); currentStorageAccount = new CloudStorageAccount(new Microsoft.WindowsAzure.Storage.Auth.StorageCredentials(accountName, accountInfo.Key), accountInfo.UseHttps); table = currentStorageAccount.CreateCloudTableClient().GetTableReference(tableName); Grid.DataSource = new TableEntityDataSource(currentStorageAccount.CreateCloudTableClient().GetTableReference(tableName), Application); Grid.DataSource.DataChanged += OnDataLoad; }
public Crawler() { storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString")); urlQueue = storageAccount.CreateCloudQueueClient().GetQueueReference("krawlerurl"); cmdQueue = storageAccount.CreateCloudQueueClient().GetQueueReference("krawlercmd"); index = storageAccount.CreateCloudTableClient().GetTableReference("krawlerindex"); errorQueue = storageAccount.CreateCloudQueueClient().GetQueueReference("krawlererror"); lastTenUrlQueue = storageAccount.CreateCloudQueueClient().GetQueueReference("lasttenurlcrawled"); crawlStatTable = storageAccount.CreateCloudTableClient().GetTableReference("krawlerstattable"); disallowedPaths = new List<string>(); visited = new HashSet<string>(); crawlStatTable.CreateIfNotExists(); crawlCounter = (NumberOfUrlCrawled() != 0) ? NumberOfUrlCrawled() : 0; }
void RemoveFromTable() { try { //Setup connection to the azure table Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse(ConfigurationManager.ConnectionStrings["TableConnectionString"].ConnectionString); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable entryTable = tableClient.GetTableReference(tableName); //Query all rows then calls them to be deleted var entities = entryTable.ExecuteQuery(new TableQuery <DynamicTableEntity>()).ToList(); foreach (var row in entities) { TableOperation deleteOP = TableOperation.Delete(row); entryTable.ExecuteAsync(deleteOP); } //Print update status to user Results1.Text += "<br />Removed from Azure Table"; } catch (Exception ex) { Error1.Text = "Failed to remove from table"; } }
public static async Task <IActionResult> Run( [HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req, ILogger log) { log.LogInformation("C# HTTP trigger function processed a request."); string name = req.Query["stockName"]; string requestBody = await new StreamReader(req.Body).ReadToEndAsync(); dynamic data = JsonConvert.DeserializeObject(requestBody); name = name ?? data?.stockName; if (string.IsNullOrEmpty(name)) { return(new BadRequestResult()); } var connectionString = "DefaultEndpointsProtocol=https;AccountName=storageaccount4471b6a6;AccountKey=dX2VUCuxC0EcRnyZ7Srg+XIKLLagAO30kkpcBcsv9bq91rG+h2FomX6EHP/IByNzKSxVdRIqq6phUYDQ3PAPnw==;EndpointSuffix=core.windows.net"; Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = CloudStorageAccount.Parse(connectionString); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable table = tableClient.GetTableReference("stocksinfo"); var summary = GetSummary(table, name); if (summary == null) { return(new NotFoundResult());; } return(new OkObjectResult(JsonConvert.SerializeObject(summary))); }
public TableStorageJobEventContext(CloudStorageAccount storageAccount, string jobsTableName = "Jobs", string jobInstancesTableName = "JobInstances", string jobInstanceEventsTableName = "JobInstanceEvents") { var tableClient = storageAccount.CreateCloudTableClient(); _jobsWriter = new TableWriter(tableClient, jobsTableName); _jobInstancesWriter = new TableWriter(tableClient, jobInstancesTableName); _jobInstanceEventsWriter = new TableWriter(tableClient, jobInstanceEventsTableName); }
public TProduct(string affiliate, string code, int qty, bool force_lookup = false) { ProductCode = code; Qty = qty; cloud = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("AbundaStorage")); client = cloud.CreateCloudTableClient(); products = client.GetTableReference("Products"); products.CreateIfNotExists(); using (var context = new DataBaseDataContext()) { var aff = (from ev in context.Affiliates where ev.code == affiliate select ev).FirstOrDefault(); merchantID = aff.MerchantID; marketplaceID = aff.MarketPlaceID; secretKey = aff.SecretKey; accessKey = aff.AccessKey; } var amzResults = PerformAmazonLookup(); }
public BuildUtil(CloudStorageAccount account) { var client = account.CreateCloudTableClient(); _buildResultDateTable = client.GetTableReference(AzureConstants.TableNames.BuildResultDate); _buildFailureDateTable = client.GetTableReference(AzureConstants.TableNames.BuildFailureDate); _viewNameDateTable = client.GetTableReference(AzureConstants.TableNames.ViewNameDate); }
public HomeController() { storageAccount = CloudStorageAccount.Parse( ConfigurationManager.AppSettings["StorageConnectionString"]); tableClient = storageAccount.CreateCloudTableClient(); table = tableClient.GetTableReference("fouramigos"); table.CreateIfNotExists(); blobClient = storageAccount.CreateCloudBlobClient(); container = blobClient.GetContainerReference("fouramigos"); container.CreateIfNotExists(); BlobContainerPermissions permissions = container.GetPermissions(); permissions.PublicAccess = BlobContainerPublicAccessType.Container; container.SetPermissions(permissions); //lägga till nya //var tablemodels = new TableModel("Brutus", "Uggla") { Location = "T4", Description="Uggla i träd", Type="Foto" }; //var tablemodels1 = new TableModel("brutus", "Örn") { Location = "T4", Description="Örn som flyger", Type = "Foto" }; //var opreation = TableOperation.Insert(tablemodels); //var operation2 = TableOperation.Insert(tablemodels1); //table.Execute(opreation); //table.Execute(operation2); }
public async static void Log( string storageAccountName, string storageAccountKey, string exceptionsTableName, string exceptionSource, string exceptionDescription, ILogger logger = null) { DateTime dt = DateTime.UtcNow; try { StorageCredentials storageCredentials = new StorageCredentials(storageAccountName, storageAccountKey); CloudStorageAccount storageAccount = new CloudStorageAccount(storageCredentials, true); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); tableClient.DefaultRequestOptions.RetryPolicy = new ExponentialRetry(TimeSpan.FromSeconds(1), 10); CloudTable table_AppExceptions = tableClient.GetTableReference(exceptionsTableName); await table_AppExceptions.CreateIfNotExistsAsync(); ExceptionLog entity = new ExceptionLog((DateTime.MaxValue - dt).ToString()); entity.DT = dt; entity.MachineName = Environment.MachineName; entity.Application = Assembly.GetEntryAssembly().GetName().Name; entity.Source = exceptionSource; entity.Description = exceptionDescription; await table_AppExceptions.ExecuteAsync(TableOperation.Insert(entity)); } catch (System.Exception ex) { if (logger != null) { logger.Error(exceptionSource + ":" + exceptionDescription + ": " + ex.ToString()); } Console.WriteLine(dt.ToString() + " " + Environment.MachineName + ":" + Assembly.GetEntryAssembly().GetName().Name + ":" + exceptionSource + ":" + exceptionDescription + ": " + ex.ToString()); } }
public static async Task <IActionResult> Run( [HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req, ILogger log) { log.LogInformation("C# HTTP trigger function processed a request."); string requestBody = await new StreamReader(req.Body).ReadToEndAsync(); StockNamesModel data = JsonConvert.DeserializeObject <StockNamesModel>(requestBody); if (data.stockNames == null || data.stockNames.Count <= 0) { return(new BadRequestResult()); } var connectionString = "DefaultEndpointsProtocol=https;AccountName=storageaccount4471b6a6;AccountKey=dX2VUCuxC0EcRnyZ7Srg+XIKLLagAO30kkpcBcsv9bq91rG+h2FomX6EHP/IByNzKSxVdRIqq6phUYDQ3PAPnw==;EndpointSuffix=core.windows.net"; Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = CloudStorageAccount.Parse(connectionString); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable table = tableClient.GetTableReference("stocksinfo"); var comparisonList = new StockComparisonInfo(); foreach (var s in data.stockNames) { var info = StockSummary.GetSummary(table, s); comparisonList.StockSummaries.Add(info); } return(new OkObjectResult(JsonConvert.SerializeObject(comparisonList))); }
protected override void Initialize(HttpControllerContext controllerContext) { base.Initialize(controllerContext); storageAccount = CloudStorageAccount.Parse("UseDevelopmentStorage=true"); var tableClient = storageAccount.CreateCloudTableClient(); table = tableClient.GetTableReference("people"); }
public static void CreateClassRooms(int number, int building, int floor, int capacity, string description) { StorageCredentials creds = new StorageCredentials(accountName, accountKey); CloudStorageAccount storageAccount = new CloudStorageAccount(creds, useHttps: true); // Create the table client. CloudTableClient classRoomClient = storageAccount.CreateCloudTableClient(); // Create the table if it doesn't exist. CloudTable table = classRoomClient.GetTableReference("ClassRoom"); table.CreateIfNotExists(); // Create the entity. ClassRoomEntity foo = new ClassRoomEntity(number, building); foo.Floor = floor; foo.Capacity = capacity; foo.Description = description; // Create the TableOperation that inserts the customer entity. TableOperation insertOperation = TableOperation.Insert(foo); // Execute the insert operation. table.Execute(insertOperation); }
public SensorAccess() { credentials = new StorageCredentials(_accountName, _key); storageAccount = new CloudStorageAccount(credentials, true); tableClient = storageAccount.CreateCloudTableClient(); table = tableClient.GetTableReference("AccelerometerTable"); }
static NDIAzureTableController() { _storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString")); _tableClient = _storageAccount.CreateCloudTableClient(); _table = _tableClient.GetTableReference("ndiparams"); _retrieveOperation = TableOperation.Retrieve("VidParams", "LastVideo"); }
public TestDataController() { _storageAccount = ControllerUtil.CreateStorageAccount(); _storage = new TestResultStorage(_storageAccount); _stats = new TestCacheStats(_storage, _storageAccount.CreateCloudTableClient()); _statsUtil = ControllerUtil.GetOrCreateCounterStatsUtil(_storageAccount); }
public ProcessTrackInfoHelper(string strConn) { storageAccount = CloudStorageAccount.Parse(strConn); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); // Create the table if it doesn't exist. table = tableClient.GetTableReference("wamsbutlerprocesstrack"); table.CreateIfNotExists(); }
public AzureEventStore(CloudStorageAccount account, string tableName) { this.account = account; this.client = account.CreateCloudTableClient(); this.tableName = tableName; this.created = false; }
public static void Initialize(string storageConnectionString) { // Get storage account _storageAccount = CloudStorageAccount.Parse(storageConnectionString); // Create the clients _tableClient = _storageAccount.CreateCloudTableClient(); }
static GuestBookDataSource() { storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("DataConnectionString")); CloudTableClient cloudTableClient = storageAccount.CreateCloudTableClient(); CloudTable table = cloudTableClient.GetTableReference("GuestBookEntry"); table.CreateIfNotExists(); }
public ChatBackup(CloudStorageAccount storageAccount) { var client = storageAccount.CreateCloudTableClient(); _table = client.GetTableReference("Chat"); _table.CreateIfNotExists(); _iDbService = new DbService(); _retryPolicy = _iDbService.GetRetryPolicy(); }
public PostBackup(CloudStorageAccount storageAccount, string endpointUrl, string authorizationKey) { _iDbService = new DbService(endpointUrl,authorizationKey); CloudTableClient c = storageAccount.CreateCloudTableClient(); _table = c.GetTableReference("Post"); _table.CreateIfNotExists(); _retryPolicy = _iDbService.GetRetryPolicy(); }
public PostBackup(CloudStorageAccount storageAccount) { _iDbService = new DbService(); CloudTableClient c = storageAccount.CreateCloudTableClient(); _table = c.GetTableReference("Post"); _table.CreateIfNotExists(); _retryPolicy = RetryService.GetRetryPolicy(); }
public async Task<CloudTable> GetTable(string tablename) { var account = new CloudStorageAccount(new StorageCredentials("slavapp", WebConfigurationManager.AppSettings["AzureStorageKey"]), true); var client = account.CreateCloudTableClient(); var table = client.GetTableReference(tablename); await table.CreateIfNotExistsAsync(); return table; }
private async Task StartAsync(CloudStorageAccount cloudStorageAccount, string tableName) { _cloudTableClient = cloudStorageAccount.CreateCloudTableClient(); _cloudTable = _cloudTableClient.GetTableReference(tableName); // create container if it does not exist on startup await _cloudTable.CreateIfNotExistAsync(); }
public TableUserIndexBuilder(CloudStorageAccount storageAccount, string userTableName, string userIndexTableName) { CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); _userTable = tableClient.GetTableReference(userTableName); _userIndexTable = tableClient.GetTableReference(userIndexTableName); _userIndexTable.CreateIfNotExists(); }
/// <summary> /// Creates class instance /// </summary> /// <param name="storageAccountName">Storage account name</param> /// <param name="storageAccountKey">Storage account key</param> /// <param name="tableName">Target table name</param> public AzureTableLogWriter(string storageAccountName, string storageAccountKey, string tableName) { var creds = new StorageCredentials(storageAccountName, storageAccountKey); var account = new CloudStorageAccount(creds, true); CloudTableClient tableClient = account.CreateCloudTableClient(); _table = tableClient.GetTableReference(tableName); _table.CreateIfNotExists(); }
public override void ActivateOptions() { base.ActivateOptions(); _account = CloudStorageAccount.Parse(ConnectionString); _client = _account.CreateCloudTableClient(); _table = _client.GetTableReference(TableName); _table.CreateIfNotExists(); }
public UserRepository() { // Retrieve the storage account from the connection string. _storageAccount = CloudStorageAccount.Parse( ConfigurationManager.AppSettings["StorageConnectionString"]); var client = _storageAccount.CreateCloudTableClient(); client.GetTableReference(TableStorageConstants.UserTableKey).CreateIfNotExists(); }
/// <summary> /// Returns the AZURE Storage Table to log the service calls in. /// Table Name : RedPillLog /// </summary> /// <returns></returns> static CloudTable GetCloudTable() { StorageCredentials creds = new StorageCredentials(AccountName, AccountKey); CloudStorageAccount account = new CloudStorageAccount(creds, useHttps: true); CloudTableClient client = account.CreateCloudTableClient(); CloudTable table = client.GetTableReference("RedPillLog"); table.CreateIfNotExists(); return table; }
public AzureClient() { var storageCredentials = new StorageCredentials("galileospslon15", ""); CloudStorageAccount storageAccount = new CloudStorageAccount(storageCredentials, true); CloudTableClient client = storageAccount.CreateCloudTableClient(); roomTable = client.GetTableReference("roomstatus"); }
/// <summary> /// Construct a sink that saves logs to the specified storage account. /// </summary> /// <param name="storageAccount">The Cloud Storage Account to use to insert the log entries to.</param> /// <param name="formatProvider">Supplies culture-specific formatting information, or null.</param> /// <param name="storageTableName">Table name that log entries will be written to. Note: Optional, setting this may impact performance</param> public AzureTableStorageSink(CloudStorageAccount storageAccount, IFormatProvider formatProvider, string storageTableName = null) { _formatProvider = formatProvider; var tableClient = storageAccount.CreateCloudTableClient(); if (string.IsNullOrEmpty(storageTableName)) storageTableName = typeof(LogEventEntity).Name; _table = tableClient.GetTableReference(storageTableName); _table.CreateIfNotExists(); }
static Microsoft.WindowsAzure.Storage.Table.CloudTable GetAzureTable() { Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageAccount")); //create cloud table client Microsoft.WindowsAzure.Storage.Table.CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); //get cloud table Microsoft.WindowsAzure.Storage.Table.CloudTable table = tableClient.GetTableReference("customers"); //cleanup table.DeleteIfExists(); table.CreateIfNotExists(); return(table); }
public Microsoft.WindowsAzure.Storage.Table.CloudTable GetTable(string tableName) { Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse( StorageConnectionString); ServicePoint tableServicePoint = ServicePointManager.FindServicePoint(storageAccount.TableEndpoint); tableServicePoint.UseNagleAlgorithm = false; Microsoft.WindowsAzure.Storage.Table.CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); // Create the table if it doesn't exist. CloudTable table = tableClient.GetTableReference(tableName); table.CreateIfNotExistsAsync().Wait(); return(table); }
public static void ProcessFile(string file) { string connectionString = ConfigurationManager.ConnectionStrings["StorageConnection"].ToString(); Microsoft.WindowsAzure.Storage.CloudStorageAccount account = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse(connectionString); StorageCredentialsAccountAndKey cre = new StorageCredentialsAccountAndKey(account.Credentials.AccountName, account.Credentials.ExportBase64EncodedKey()); Microsoft.WindowsAzure.CloudStorageAccount ac = new Microsoft.WindowsAzure.CloudStorageAccount(cre, true); CloudTableClient client = account.CreateCloudTableClient(); CloudTable table = client.GetTableReference("employe"); table.CreateIfNotExists(); var dt = DataAccess.DataTable.New.ReadAzureBlob(ac, "fileupload", file); foreach (var row in dt.Rows) { EmployeeTableEntity emp = new EmployeeTableEntity { EmployeeId = Convert.ToInt16(row["EmployeeId"]), FirstName = row["FirstName"], LastName = row["LastName"], ContactNo = row["ContactNo"], EmailId = row["EmailId"], PartitionKey = row["EmployeeId"], RowKey = Guid.NewGuid().ToString() }; TableOperation operation = TableOperation.InsertOrMerge(emp); table.Execute(operation); } }
public static Microsoft.WindowsAzure.Storage.Table.TableResult GetRandomTableResult() { //try //{ Microsoft.WindowsAzure.Storage.Table.TableResult retreiveResult = null; XmlDocument document = new XmlDocument(); document.Load(@"C:\Users\Administrator\source\repos\ConsoleApp5\ConsoleApp5\bin\Debug\Test.xml"); var appSettings = System.Configuration.ConfigurationManager.AppSettings; if (appSettings.Count == 0) { Console.WriteLine("The appsettings is empty\nEnter a valid ConnectionString in AppConfig file"); Console.WriteLine("Press a key to exit.."); Console.ReadLine(); } else { foreach (var key in appSettings.AllKeys) { Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse(System.Configuration.ConfigurationManager.AppSettings[key]); Microsoft.WindowsAzure.Storage.Table.CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); Microsoft.WindowsAzure.Storage.Table.CloudTable table = tableClient.GetTableReference("CustomerInformation"); //table.CreateIfNotExists(); /*foreach (Json_File file in json_Files) * { * Microsoft.WindowsAzure.Storage.Table.TableOperation insertOperation = Microsoft.WindowsAzure.Storage.Table.TableOperation.Insert(file); * table.Execute(insertOperation); * } */ if (table.Exists()) { Console.WriteLine("The table exists.."); //Microsoft.WindowsAzure.Storage.Table.EntityProperty.CreateEntityPropertyFromObject Dictionary <int, string> Partition_Keys = new Dictionary <int, string>(); int num = 1; Microsoft.WindowsAzure.Storage.Table.TableContinuationToken token = null; var entities = new List <Json_File>(); do { var queryResult = table.ExecuteQuerySegmented(new Microsoft.WindowsAzure.Storage.Table.TableQuery <Json_File>(), token); entities.AddRange(queryResult.Results); token = queryResult.ContinuationToken; } while (token != null); foreach (var file in entities) { Partition_Keys.Add(num, file.PartitionKey); num++; } int size = Partition_Keys.Count; Random random = new Random(); int random_number = random.Next(1, size + 1); string RandomPartitionKey = Partition_Keys[random_number]; Microsoft.WindowsAzure.Storage.Table.TableContinuationToken continuationToken = null; var Entities = new List <Json_File>(); do { var rangeQueryResult = table .ExecuteQuerySegmented(new Microsoft.WindowsAzure.Storage.Table.TableQuery <Json_File>() .Where(Microsoft.WindowsAzure.Storage.Table.TableQuery .GenerateFilterCondition("PartitionKey", Microsoft.WindowsAzure.Storage.Table.QueryComparisons.Equal, RandomPartitionKey)), continuationToken); Entities.AddRange(rangeQueryResult.Results); continuationToken = rangeQueryResult.ContinuationToken; } while (continuationToken != null); Dictionary <int, string> Row_Keys = new Dictionary <int, string>(); int number = 1; foreach (var file in Entities) { Row_Keys.Add(number, file.RowKey); number++; } int sub_size = Row_Keys.Count; Random rand = new Random(); int rand_number = rand.Next(1, sub_size + 1); string RandomRowKey = Row_Keys[rand_number]; Microsoft.WindowsAzure.Storage.Table.TableOperation retreiveOperation = Microsoft.WindowsAzure.Storage.Table.TableOperation.Retrieve <Json_File>(RandomPartitionKey, RandomRowKey); retreiveResult = table.Execute(retreiveOperation); } else { Console.WriteLine("Table doesn't exists\nPress a key to exit...."); Console.ReadLine(); } } } return(retreiveResult); /*catch (Exception ex) * { * Console.WriteLine(ex.Message); * Console.WriteLine(ex.StackTrace); * Console.WriteLine(ex.InnerException); * Console.WriteLine(ex.Source); * Console.WriteLine("Press a key to exit..."); * Console.ReadLine(); * } */ }
void ProcessQuery() { ResultTitle.Text = "Query Results"; string firstName = TextBox_firstname.Text; string lastName = TextBox_lastname.Text; //Setup connection to the azure table Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse(ConfigurationManager.ConnectionStrings["TableConnectionString"].ConnectionString); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable entryTable = tableClient.GetTableReference(tableName); //Only partition key if (firstName == string.Empty && lastName != string.Empty) { TableQuery <DynamicTableEntity> query = new TableQuery <DynamicTableEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, lastName)); TableContinuationToken token = null; do { TableQuerySegment <DynamicTableEntity> resultSegment = entryTable.ExecuteQuerySegmented(query, token); token = resultSegment.ContinuationToken; foreach (DynamicTableEntity entity in resultSegment.Results) { IDictionary <string, EntityProperty> properties = entity.Properties; Results1.Text += entity.PartitionKey + ", " + entity.RowKey + ": "; foreach (KeyValuePair <string, EntityProperty> entry in properties) { Results1.Text += entry.Key + " = " + entry.Value.StringValue + "; "; } Results1.Text += "<br />"; } } while (token != null); } //Only row key else if (firstName != string.Empty && lastName == string.Empty) { TableQuery <DynamicTableEntity> query = new TableQuery <DynamicTableEntity>().Where(TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.Equal, firstName)); TableContinuationToken token = null; do { TableQuerySegment <DynamicTableEntity> resultSegment = entryTable.ExecuteQuerySegmented(query, token); token = resultSegment.ContinuationToken; foreach (DynamicTableEntity entity in resultSegment.Results) { IDictionary <string, EntityProperty> properties = entity.Properties; Results1.Text += entity.PartitionKey + ", " + entity.RowKey + ": "; foreach (KeyValuePair <string, EntityProperty> entry in properties) { Results1.Text += entry.Key + " = " + entry.Value.StringValue + "; "; } Results1.Text += "<br />"; } } while (token != null); } //Using both keys else if (firstName != string.Empty && lastName != string.Empty) { TableOperation retrieveOp = TableOperation.Retrieve <DynamicTableEntity>(lastName, firstName); TableResult retrieved = entryTable.Execute(retrieveOp); if (retrieved.Result != null) { IDictionary <string, EntityProperty> properties = ((DynamicTableEntity)retrieved.Result).Properties; Results1.Text = ((DynamicTableEntity)retrieved.Result).PartitionKey + ", " + ((DynamicTableEntity)retrieved.Result).RowKey + ": "; foreach (KeyValuePair <string, EntityProperty> entry in properties) { Results1.Text += entry.Key + " = " + entry.Value.StringValue + "; "; } } } if (Results1.Text == string.Empty) { Results1.Text = "No results found. <br />Needs exact spelling."; } }
void UploadToTable(List <string> entries) { try { Microsoft.WindowsAzure.Storage.CloudStorageAccount storageAccount = Microsoft.WindowsAzure.Storage.CloudStorageAccount.Parse(ConfigurationManager.ConnectionStrings["TableConnectionString"].ConnectionString); CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable entryTable = tableClient.GetTableReference(tableName); entryTable.CreateIfNotExistsAsync().Wait(); ResultTitle.Text = ""; Results1.Text = ""; Error1.Text = ""; foreach (string entry in entries) { //Parse the string.. //Attempts to remove tabs and white spaces, doesnt fix the Robert williams case. char tab = '\u0009'; string newEntry = entry.Replace(tab.ToString(), " "); newEntry.Trim(); string[] arr = newEntry.Split(); //Jerry rigged to fix the robert williams case where the first substring is empty int counter = 0; if (arr[0] == string.Empty) { //Error1.Text += "String[0] is empty"; counter++; } string firstName = arr[counter]; string lastName = arr[counter + 1]; var entity = new DynamicTableEntity(lastName, firstName); string valuesToPrint = ""; if (arr.Length > 2) { for (int i = 2; i < arr.Length; i++) { int index = arr[i].IndexOf('='); if (index == -1) { continue; } string key = arr[i].Substring(0, index); string value = arr[i].Substring(index + 1); entity.Properties.Add(key, new EntityProperty(value)); valuesToPrint += key + "=" + value + " "; } } var mergeOperation = TableOperation.InsertOrMerge(entity); entryTable.ExecuteAsync(mergeOperation); ResultTitle.Text = "Merged into table:"; Results1.Text += "Name: " + lastName + ", " + firstName + " " + valuesToPrint + "<br />"; } } catch (Exception ex) { Error1.Text = "Failed to upload to table. <br />If you just cleared the table, wait for it to finish deletion."; } }