Azure Storage CRUD operations using .NET Core
I've been working with Azure Storage resources recently, particularly I was just playing around with CRUD operations in Table. I was able to accomplish a task using .NET Framework, however, recently my requirements have changed and I had to migrate to .NET Core. I wrote the same type of code by it reaches try-catch
statement in CreateTable()
and stop for no reason, I am not getting any exceptions or messages, program just exits from there. I have been trying to figure out this issue, so far I came to the following solution that seems to be missing a tiny piece to make it work.
Moreover, previously I was using CosmosDB API to perform this operations. Unfortunately, it is not available in .NET Core, therefore I came up with this solution.
My thoughts: I am concerned about authentication part as well, since I can't determine if it was successful or not. It goes through Auth()
well without problems. I would appreciate if anyone could give me the right direction to the solution of this problem. Thanks!
static CloudStorageAccount _storageAccount;
static void Main(string args)
{
Auth();
CreateTable();
}
static void Auth()
{
_storageAccount = new CloudStorageAccount(
new Microsoft.WindowsAzure.Storage.Auth.StorageCredentials(
"MyResource", "MyKey"),true);
}
async static void CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
}
}
c# azure azure-table-storage azure-blob-storage
|
show 2 more comments
I've been working with Azure Storage resources recently, particularly I was just playing around with CRUD operations in Table. I was able to accomplish a task using .NET Framework, however, recently my requirements have changed and I had to migrate to .NET Core. I wrote the same type of code by it reaches try-catch
statement in CreateTable()
and stop for no reason, I am not getting any exceptions or messages, program just exits from there. I have been trying to figure out this issue, so far I came to the following solution that seems to be missing a tiny piece to make it work.
Moreover, previously I was using CosmosDB API to perform this operations. Unfortunately, it is not available in .NET Core, therefore I came up with this solution.
My thoughts: I am concerned about authentication part as well, since I can't determine if it was successful or not. It goes through Auth()
well without problems. I would appreciate if anyone could give me the right direction to the solution of this problem. Thanks!
static CloudStorageAccount _storageAccount;
static void Main(string args)
{
Auth();
CreateTable();
}
static void Auth()
{
_storageAccount = new CloudStorageAccount(
new Microsoft.WindowsAzure.Storage.Auth.StorageCredentials(
"MyResource", "MyKey"),true);
}
async static void CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
}
}
c# azure azure-table-storage azure-blob-storage
2
Shouldn't you be awaiting the call toCreateTable
method in your Main method as this is an async method?
– Gaurav Mantri
Nov 21 '18 at 0:37
@GauravMantri good catch, but it isn’t a point
– Coke
Nov 21 '18 at 1:55
Please explain what you mean by “it isn’t a point”.
– Gaurav Mantri
Nov 21 '18 at 1:56
@GauravMantri I mean that it was a nice call, but it doesn’t anyhow help to solve this problem.
– Coke
Nov 21 '18 at 1:58
1
Thanks but now I’m confused:). You mentioned that your code/program is exiting. That was because you were not waiting for the asynchronous operation to finish. Have you tried Tom’s solution below? Are you still having the same problem?
– Gaurav Mantri
Nov 21 '18 at 2:19
|
show 2 more comments
I've been working with Azure Storage resources recently, particularly I was just playing around with CRUD operations in Table. I was able to accomplish a task using .NET Framework, however, recently my requirements have changed and I had to migrate to .NET Core. I wrote the same type of code by it reaches try-catch
statement in CreateTable()
and stop for no reason, I am not getting any exceptions or messages, program just exits from there. I have been trying to figure out this issue, so far I came to the following solution that seems to be missing a tiny piece to make it work.
Moreover, previously I was using CosmosDB API to perform this operations. Unfortunately, it is not available in .NET Core, therefore I came up with this solution.
My thoughts: I am concerned about authentication part as well, since I can't determine if it was successful or not. It goes through Auth()
well without problems. I would appreciate if anyone could give me the right direction to the solution of this problem. Thanks!
static CloudStorageAccount _storageAccount;
static void Main(string args)
{
Auth();
CreateTable();
}
static void Auth()
{
_storageAccount = new CloudStorageAccount(
new Microsoft.WindowsAzure.Storage.Auth.StorageCredentials(
"MyResource", "MyKey"),true);
}
async static void CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
}
}
c# azure azure-table-storage azure-blob-storage
I've been working with Azure Storage resources recently, particularly I was just playing around with CRUD operations in Table. I was able to accomplish a task using .NET Framework, however, recently my requirements have changed and I had to migrate to .NET Core. I wrote the same type of code by it reaches try-catch
statement in CreateTable()
and stop for no reason, I am not getting any exceptions or messages, program just exits from there. I have been trying to figure out this issue, so far I came to the following solution that seems to be missing a tiny piece to make it work.
Moreover, previously I was using CosmosDB API to perform this operations. Unfortunately, it is not available in .NET Core, therefore I came up with this solution.
My thoughts: I am concerned about authentication part as well, since I can't determine if it was successful or not. It goes through Auth()
well without problems. I would appreciate if anyone could give me the right direction to the solution of this problem. Thanks!
static CloudStorageAccount _storageAccount;
static void Main(string args)
{
Auth();
CreateTable();
}
static void Auth()
{
_storageAccount = new CloudStorageAccount(
new Microsoft.WindowsAzure.Storage.Auth.StorageCredentials(
"MyResource", "MyKey"),true);
}
async static void CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
}
}
c# azure azure-table-storage azure-blob-storage
c# azure azure-table-storage azure-blob-storage
edited Nov 21 '18 at 7:46
Jayendran
3,43331439
3,43331439
asked Nov 20 '18 at 23:48
CokeCoke
640414
640414
2
Shouldn't you be awaiting the call toCreateTable
method in your Main method as this is an async method?
– Gaurav Mantri
Nov 21 '18 at 0:37
@GauravMantri good catch, but it isn’t a point
– Coke
Nov 21 '18 at 1:55
Please explain what you mean by “it isn’t a point”.
– Gaurav Mantri
Nov 21 '18 at 1:56
@GauravMantri I mean that it was a nice call, but it doesn’t anyhow help to solve this problem.
– Coke
Nov 21 '18 at 1:58
1
Thanks but now I’m confused:). You mentioned that your code/program is exiting. That was because you were not waiting for the asynchronous operation to finish. Have you tried Tom’s solution below? Are you still having the same problem?
– Gaurav Mantri
Nov 21 '18 at 2:19
|
show 2 more comments
2
Shouldn't you be awaiting the call toCreateTable
method in your Main method as this is an async method?
– Gaurav Mantri
Nov 21 '18 at 0:37
@GauravMantri good catch, but it isn’t a point
– Coke
Nov 21 '18 at 1:55
Please explain what you mean by “it isn’t a point”.
– Gaurav Mantri
Nov 21 '18 at 1:56
@GauravMantri I mean that it was a nice call, but it doesn’t anyhow help to solve this problem.
– Coke
Nov 21 '18 at 1:58
1
Thanks but now I’m confused:). You mentioned that your code/program is exiting. That was because you were not waiting for the asynchronous operation to finish. Have you tried Tom’s solution below? Are you still having the same problem?
– Gaurav Mantri
Nov 21 '18 at 2:19
2
2
Shouldn't you be awaiting the call to
CreateTable
method in your Main method as this is an async method?– Gaurav Mantri
Nov 21 '18 at 0:37
Shouldn't you be awaiting the call to
CreateTable
method in your Main method as this is an async method?– Gaurav Mantri
Nov 21 '18 at 0:37
@GauravMantri good catch, but it isn’t a point
– Coke
Nov 21 '18 at 1:55
@GauravMantri good catch, but it isn’t a point
– Coke
Nov 21 '18 at 1:55
Please explain what you mean by “it isn’t a point”.
– Gaurav Mantri
Nov 21 '18 at 1:56
Please explain what you mean by “it isn’t a point”.
– Gaurav Mantri
Nov 21 '18 at 1:56
@GauravMantri I mean that it was a nice call, but it doesn’t anyhow help to solve this problem.
– Coke
Nov 21 '18 at 1:58
@GauravMantri I mean that it was a nice call, but it doesn’t anyhow help to solve this problem.
– Coke
Nov 21 '18 at 1:58
1
1
Thanks but now I’m confused:). You mentioned that your code/program is exiting. That was because you were not waiting for the asynchronous operation to finish. Have you tried Tom’s solution below? Are you still having the same problem?
– Gaurav Mantri
Nov 21 '18 at 2:19
Thanks but now I’m confused:). You mentioned that your code/program is exiting. That was because you were not waiting for the asynchronous operation to finish. Have you tried Tom’s solution below? Are you still having the same problem?
– Gaurav Mantri
Nov 21 '18 at 2:19
|
show 2 more comments
1 Answer
1
active
oldest
votes
I wrote the same type of code by it reaches try-catch statement in CreateTable() and stop for no reason.
As the CreateTable() is an async method, the program will exit with no wait to get exectution result.
I would appreciate if anyone could give me the right direction to the solution of this problem
Please have a try to use the following demo code. If get the 204 in the console meanings that create table and insert record to the table successfully, or you will get the exception information in the console.
static void Main(string args)
{
Auth();
var result = CreateTable().Result;
Console.WriteLine(result);
Console.ReadKey();
}
async static Task<string> CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
return result.HttpStatusCode.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return null;
}
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53403326%2fazure-storage-crud-operations-using-net-core%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I wrote the same type of code by it reaches try-catch statement in CreateTable() and stop for no reason.
As the CreateTable() is an async method, the program will exit with no wait to get exectution result.
I would appreciate if anyone could give me the right direction to the solution of this problem
Please have a try to use the following demo code. If get the 204 in the console meanings that create table and insert record to the table successfully, or you will get the exception information in the console.
static void Main(string args)
{
Auth();
var result = CreateTable().Result;
Console.WriteLine(result);
Console.ReadKey();
}
async static Task<string> CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
return result.HttpStatusCode.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return null;
}
add a comment |
I wrote the same type of code by it reaches try-catch statement in CreateTable() and stop for no reason.
As the CreateTable() is an async method, the program will exit with no wait to get exectution result.
I would appreciate if anyone could give me the right direction to the solution of this problem
Please have a try to use the following demo code. If get the 204 in the console meanings that create table and insert record to the table successfully, or you will get the exception information in the console.
static void Main(string args)
{
Auth();
var result = CreateTable().Result;
Console.WriteLine(result);
Console.ReadKey();
}
async static Task<string> CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
return result.HttpStatusCode.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return null;
}
add a comment |
I wrote the same type of code by it reaches try-catch statement in CreateTable() and stop for no reason.
As the CreateTable() is an async method, the program will exit with no wait to get exectution result.
I would appreciate if anyone could give me the right direction to the solution of this problem
Please have a try to use the following demo code. If get the 204 in the console meanings that create table and insert record to the table successfully, or you will get the exception information in the console.
static void Main(string args)
{
Auth();
var result = CreateTable().Result;
Console.WriteLine(result);
Console.ReadKey();
}
async static Task<string> CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
return result.HttpStatusCode.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return null;
}
I wrote the same type of code by it reaches try-catch statement in CreateTable() and stop for no reason.
As the CreateTable() is an async method, the program will exit with no wait to get exectution result.
I would appreciate if anyone could give me the right direction to the solution of this problem
Please have a try to use the following demo code. If get the 204 in the console meanings that create table and insert record to the table successfully, or you will get the exception information in the console.
static void Main(string args)
{
Auth();
var result = CreateTable().Result;
Console.WriteLine(result);
Console.ReadKey();
}
async static Task<string> CreateTable()
{
CloudTableClient tableClient = _storageAccount.CreateCloudTableClient();
CloudTable peopleTable = tableClient.GetTableReference("XYZ");
try
{
await peopleTable.CreateIfNotExistsAsync();
People customer = new People("Garry", "Johnson");
customer.Email = "xxx@yyy.zzz";
customer.PhoneNumber = "123456789";
TableOperation insertOperation = TableOperation.Insert(customer);
var result = await peopleTable.ExecuteAsync(insertOperation);
return result.HttpStatusCode.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return null;
}
edited Nov 21 '18 at 2:23
answered Nov 21 '18 at 1:55
Tom SunTom Sun
17.6k2923
17.6k2923
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53403326%2fazure-storage-crud-operations-using-net-core%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Shouldn't you be awaiting the call to
CreateTable
method in your Main method as this is an async method?– Gaurav Mantri
Nov 21 '18 at 0:37
@GauravMantri good catch, but it isn’t a point
– Coke
Nov 21 '18 at 1:55
Please explain what you mean by “it isn’t a point”.
– Gaurav Mantri
Nov 21 '18 at 1:56
@GauravMantri I mean that it was a nice call, but it doesn’t anyhow help to solve this problem.
– Coke
Nov 21 '18 at 1:58
1
Thanks but now I’m confused:). You mentioned that your code/program is exiting. That was because you were not waiting for the asynchronous operation to finish. Have you tried Tom’s solution below? Are you still having the same problem?
– Gaurav Mantri
Nov 21 '18 at 2:19