Azure table query to csv c#

Question

I'm trying to write an Azure table Storage Query result to a .csv file and store it locally on the machine (temp is fine). I'm able to query without issue - then display the results in a messageBox. I'm doing this using c#. I don't want to use an external application, but will call on a powershell script if that is what it takes. Ultimately, I'm trying to download the csv so I query the csv file instead of azure tables storage for more functionality. (SQL Server isn't an option at this time - although I do understand it would make my life so much easier) CloudStorageAccount storageAccount = CloudStorageAccount.Parse ("DefaultEndpointsProtocol=https;AccountName=MyStorageAccountNameHere;AccountKey=MyTableKeyhere CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable table = tableClient.GetTableReference("TelephonyIssueLog"); var managerQuery = new TableQuery().Where(TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.Equal, "Issues")); System.IO.File.WriteAllText(@"C:\temp\csv.csv", managerQuery); JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

I actually figured it out: starting with the top using CsvHelper; if (string.IsNullOrEmpty(txtFirstN.Text) || string.IsNullOrEmpty(txtLName.Text) || string.IsNullOrEmpty(cbDirection.Text) || string.IsNullOrEmpty(cbPhoneSystem.Text) || string.IsNullOrEmpty(txtCustPhone.Text) || string.IsNullOrEmpty(txtManager.Text) || string.IsNullOrEmpty(txtProgram.Text) || string.IsNullOrEmpty(cbLocation.Text) || string.IsNullOrEmpty(txtPhoneNumber.Text) || string.IsNullOrEmpty(cbIssue.Text) || string.IsNullOrEmpty(cbPhoneSystem.Text)) { MessageBox.Show("Please Fill out the WHOLE Form. Thank you!"); } else { CloudStorageAccount storageAccount = CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;AccountName=myaccountname;AccountKey=my-account-key CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable table = tableClient.GetTableReference("TelephonyIssueLog"); //Await is a good command to use here so we don't try to go forward before we verify the table actually exists and error out. //Notice I made the function async. C# is annoying as all out when using async and await so yeah have fun with that :D. -=Chris await table.CreateIfNotExistsAsync(); IssueEntity IssueLog = new IssueEntity("Issues", lblRandom.Text); IssueLog.FirstName = txtFirstN.Text; IssueLog.LastName = txtLName.Text; IssueLog.CallDirection = cbDirection.Text; IssueLog.CustNumber = txtCustPhone.Text; //IssueLog.FirstName = tbFirstName.Text; //IssueLog.LastName = tbLastName.Text; IssueLog.Location = cbLocation.Text; IssueLog.Manager = txtManager.Text; IssueLog.PhoneNumber = txtPhoneNumber.Text; IssueLog.PhoneSystem = cbPhoneSystem.Text; IssueLog.PrimaryIssue = cbIssue.Text; IssueLog.Program = txtProgram.Text; TableOperation insertOperation = TableOperation.Insert(IssueLog); table.Execute(insertOperation); Then, comes the query and CSV Edit: //get to the cloud storage CloudStorageAccount storageAccount = CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;AccountName=my-account-name;AccountKey=My-Account-Key CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); CloudTable table = tableClient.GetTableReference("TelephonyIssueLog"); Worked like a charm! //initiate the writer var sw = new StreamWriter(@"C:\ProgramData\N3RASupportNotifier\Test.csv"); var writer = new CsvWriter(sw); TableQuery query = new TableQuery().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Issues")); //Write each record to CSV foreach (IssueEntity entity in table.ExecuteQuery(query)) { writer.WriteField(entity.FirstName); writer.WriteField(entity.LastName); writer.WriteField(entity.Location); writer.WriteField(entity.Manager); writer.WriteField(entity.PartitionKey); writer.WriteField(entity.PhoneSystem); writer.WriteField(entity.PrimaryIssue); writer.WriteField(entity.Timestamp); writer.NextRecord(); }