connection to Azure table storage fails
up vote
1
down vote
favorite
I am working on a new web app and I am trying to connect to an existing Azure table storage.
using System.Web.Mvc;
using Microsoft.Azure;
using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Table;
using System;
namespace WebApplication3.Controllers
{
public class GetEmailAddressesController : Controller
{
public ActionResult Address()
{
string emails = "";
// Parse the connection string and return a reference to the storage account.
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
// Create the table client.
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("experimentsEmailAddresses");
// Construct a table query.
TableQuery<TableData> query = new TableQuery<TableData>();
foreach (TableData entity in table.ExecuteQuery(query))
{
emails += entity.Email + ";";
}
ViewBag.Message = " " + emails;
return View();
}
}
}
The code will compile but when I run it on debug mode I get an error:
System.ArgumentNullException: 'Value cannot be null. Parameter name: connectionString'
i.e my connection string isn't valid, Although I copied it from the Access keys in Azure.
What is the best solution for that?
.net
|
show 3 more comments
up vote
1
down vote
favorite
I am working on a new web app and I am trying to connect to an existing Azure table storage.
using System.Web.Mvc;
using Microsoft.Azure;
using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Table;
using System;
namespace WebApplication3.Controllers
{
public class GetEmailAddressesController : Controller
{
public ActionResult Address()
{
string emails = "";
// Parse the connection string and return a reference to the storage account.
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
// Create the table client.
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("experimentsEmailAddresses");
// Construct a table query.
TableQuery<TableData> query = new TableQuery<TableData>();
foreach (TableData entity in table.ExecuteQuery(query))
{
emails += entity.Email + ";";
}
ViewBag.Message = " " + emails;
return View();
}
}
}
The code will compile but when I run it on debug mode I get an error:
System.ArgumentNullException: 'Value cannot be null. Parameter name: connectionString'
i.e my connection string isn't valid, Although I copied it from the Access keys in Azure.
What is the best solution for that?
.net
Where are you storing your connection string within the config file?
– Rob Reagan
Nov 11 at 15:57
under web.config I added <add key="StorageConnectionString" value="___" />
– I.zv
Nov 11 at 15:59
Specifically, it is under appSettings or connectionStrings?
– Rob Reagan
Nov 11 at 16:00
it is under appSettings
– I.zv
Nov 11 at 17:00
My other suggestion would be to: 1. Step through and make sure that CloudConfigurationManager.GetSetting("________")); is returning what you think it is. 2. Take the connection string returned by your app and attempt to connect through Azure Storage Explorer.
– Rob Reagan
Nov 11 at 17:57
|
show 3 more comments
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I am working on a new web app and I am trying to connect to an existing Azure table storage.
using System.Web.Mvc;
using Microsoft.Azure;
using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Table;
using System;
namespace WebApplication3.Controllers
{
public class GetEmailAddressesController : Controller
{
public ActionResult Address()
{
string emails = "";
// Parse the connection string and return a reference to the storage account.
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
// Create the table client.
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("experimentsEmailAddresses");
// Construct a table query.
TableQuery<TableData> query = new TableQuery<TableData>();
foreach (TableData entity in table.ExecuteQuery(query))
{
emails += entity.Email + ";";
}
ViewBag.Message = " " + emails;
return View();
}
}
}
The code will compile but when I run it on debug mode I get an error:
System.ArgumentNullException: 'Value cannot be null. Parameter name: connectionString'
i.e my connection string isn't valid, Although I copied it from the Access keys in Azure.
What is the best solution for that?
.net
I am working on a new web app and I am trying to connect to an existing Azure table storage.
using System.Web.Mvc;
using Microsoft.Azure;
using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Table;
using System;
namespace WebApplication3.Controllers
{
public class GetEmailAddressesController : Controller
{
public ActionResult Address()
{
string emails = "";
// Parse the connection string and return a reference to the storage account.
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
// Create the table client.
CloudTableClient tableClient = storageAccount.CreateCloudTableClient();
CloudTable table = tableClient.GetTableReference("experimentsEmailAddresses");
// Construct a table query.
TableQuery<TableData> query = new TableQuery<TableData>();
foreach (TableData entity in table.ExecuteQuery(query))
{
emails += entity.Email + ";";
}
ViewBag.Message = " " + emails;
return View();
}
}
}
The code will compile but when I run it on debug mode I get an error:
System.ArgumentNullException: 'Value cannot be null. Parameter name: connectionString'
i.e my connection string isn't valid, Although I copied it from the Access keys in Azure.
What is the best solution for that?
.net
.net
asked Nov 11 at 15:53
I.zv
1029
1029
Where are you storing your connection string within the config file?
– Rob Reagan
Nov 11 at 15:57
under web.config I added <add key="StorageConnectionString" value="___" />
– I.zv
Nov 11 at 15:59
Specifically, it is under appSettings or connectionStrings?
– Rob Reagan
Nov 11 at 16:00
it is under appSettings
– I.zv
Nov 11 at 17:00
My other suggestion would be to: 1. Step through and make sure that CloudConfigurationManager.GetSetting("________")); is returning what you think it is. 2. Take the connection string returned by your app and attempt to connect through Azure Storage Explorer.
– Rob Reagan
Nov 11 at 17:57
|
show 3 more comments
Where are you storing your connection string within the config file?
– Rob Reagan
Nov 11 at 15:57
under web.config I added <add key="StorageConnectionString" value="___" />
– I.zv
Nov 11 at 15:59
Specifically, it is under appSettings or connectionStrings?
– Rob Reagan
Nov 11 at 16:00
it is under appSettings
– I.zv
Nov 11 at 17:00
My other suggestion would be to: 1. Step through and make sure that CloudConfigurationManager.GetSetting("________")); is returning what you think it is. 2. Take the connection string returned by your app and attempt to connect through Azure Storage Explorer.
– Rob Reagan
Nov 11 at 17:57
Where are you storing your connection string within the config file?
– Rob Reagan
Nov 11 at 15:57
Where are you storing your connection string within the config file?
– Rob Reagan
Nov 11 at 15:57
under web.config I added <add key="StorageConnectionString" value="___" />
– I.zv
Nov 11 at 15:59
under web.config I added <add key="StorageConnectionString" value="___" />
– I.zv
Nov 11 at 15:59
Specifically, it is under appSettings or connectionStrings?
– Rob Reagan
Nov 11 at 16:00
Specifically, it is under appSettings or connectionStrings?
– Rob Reagan
Nov 11 at 16:00
it is under appSettings
– I.zv
Nov 11 at 17:00
it is under appSettings
– I.zv
Nov 11 at 17:00
My other suggestion would be to: 1. Step through and make sure that CloudConfigurationManager.GetSetting("________")); is returning what you think it is. 2. Take the connection string returned by your app and attempt to connect through Azure Storage Explorer.
– Rob Reagan
Nov 11 at 17:57
My other suggestion would be to: 1. Step through and make sure that CloudConfigurationManager.GetSetting("________")); is returning what you think it is. 2. Take the connection string returned by your app and attempt to connect through Azure Storage Explorer.
– Rob Reagan
Nov 11 at 17:57
|
show 3 more comments
2 Answers
2
active
oldest
votes
up vote
0
down vote
I think you should change:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
To:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
Hope it helps!
add a comment |
up vote
0
down vote
accepted
I changed
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
to
CloudStorageAccount storageAccount = cloudStorageAccount.Parse("StorageConnectionString");
And it seems to work perfectly.
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I think you should change:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
To:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
Hope it helps!
add a comment |
up vote
0
down vote
I think you should change:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
To:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
Hope it helps!
add a comment |
up vote
0
down vote
up vote
0
down vote
I think you should change:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
To:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
Hope it helps!
I think you should change:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("________"));
To:
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
Hope it helps!
answered Nov 12 at 6:32
Itay Podhajcer
1,117312
1,117312
add a comment |
add a comment |
up vote
0
down vote
accepted
I changed
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
to
CloudStorageAccount storageAccount = cloudStorageAccount.Parse("StorageConnectionString");
And it seems to work perfectly.
add a comment |
up vote
0
down vote
accepted
I changed
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
to
CloudStorageAccount storageAccount = cloudStorageAccount.Parse("StorageConnectionString");
And it seems to work perfectly.
add a comment |
up vote
0
down vote
accepted
up vote
0
down vote
accepted
I changed
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
to
CloudStorageAccount storageAccount = cloudStorageAccount.Parse("StorageConnectionString");
And it seems to work perfectly.
I changed
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
CloudConfigurationManager.GetSetting("StorageConnectionString"));
to
CloudStorageAccount storageAccount = cloudStorageAccount.Parse("StorageConnectionString");
And it seems to work perfectly.
answered Nov 15 at 10:27
I.zv
1029
1029
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53250464%2fconnection-to-azure-table-storage-fails%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
Where are you storing your connection string within the config file?
– Rob Reagan
Nov 11 at 15:57
under web.config I added <add key="StorageConnectionString" value="___" />
– I.zv
Nov 11 at 15:59
Specifically, it is under appSettings or connectionStrings?
– Rob Reagan
Nov 11 at 16:00
it is under appSettings
– I.zv
Nov 11 at 17:00
My other suggestion would be to: 1. Step through and make sure that CloudConfigurationManager.GetSetting("________")); is returning what you think it is. 2. Take the connection string returned by your app and attempt to connect through Azure Storage Explorer.
– Rob Reagan
Nov 11 at 17:57