C# Generate Azure Table Storage ConnectionString

Question

I want to generate connectionString for azure table storage using azure subscriptionId and azureApiKey.

I found the following Microsoft library: https://github.com/Azure/azure-libraries-for-net/tree/master but can't understand how can I generate connectionString here. I can't even find appropriate method for it.

Do I need additional data to generate ConnectionString?

hujtomi · Answer 1 · 2018-05-26T23:50:23.570

1

You don't really need to generate it, you can just go in to the azure portal and just create a storage account any copy the connections string:

But, if you want to generate it, you can just fill this string with your account name and key: "DefaultEndpointsProtocol=https;AccountName={yourAccountName};AccountKey={yourAccountKey};EndpointSuffix=core.windows.net"

If you want to use the .net library, you can find the example here: https://github.com/Azure-Samples/storage-dotnet-manage-storage-accounts

edited May 26 '18 at 23:50

answered May 26 '18 at 23:45

hujtomi

1,540
2
17
23

Okay, but I need to generate connectionString on runtime only using AzureSubscriptionId and AzureApiKey and save it in another collection. What's the solution for this? – David Maisuradze May 27 '18 at 15:34

score 1 · Accepted Answer · answered May 28 '18 at 03:03

Do I need additional data to generate ConnectionString?

Preparation:

1.Registry an app in the Azure AD and create service principal for accessing the resource. More detail please refer to the document.

2.Prepare the authentication file with the content as following format. The values can be got from the step 1.

subscription=########-####-####-####-############
client=########-####-####-####-############
key=XXXXXXXXXXXXXXXX
tenant=########-####-####-####-############
managementURI=https\://management.core.windows.net/
baseURL=https\://management.azure.com/
authURL=https\://login.windows.net/
graphURL=https\://graph.windows.net/

3.Install the libraries Microsoft.Azure.Management.Fluent and Microsoft.Azure.Management.ResourceManager.Fluent in the project

Demo Code:

var credFile = @"auth file path"; // example: c:\tom\auth.txt
var keyName = "key1";
var azure = Azure
            .Configure()
            .WithLogLevel(HttpLoggingDelegatingHandler.Level.Basic)
            .Authenticate(credentials)
            .WithDefaultSubscription(); 
var storageAccount = azure.StorageAccounts.GetByResourceGroup(resourceGroupName, storageName);
var key = storageAccount.RegenerateKey(keyName);
var connectionString = $"DefaultEndpointsProtocol=http;AccountName={storageAccount.Name};AccountKey={key.FirstOrDefault()?.Value}";

Test Result:

Thanks Tom for brief and excellent information. But I need to create StorageAccount on runtime. could you please provide the sample for this? — David Maisuradze, May 30 '18 at 12:04
`var accounts = azure.StorageAccounts.Define("storageName").WithRegion("region").WithExistingResourceGroup("resourcegroupname").Create();` — Tom Sun - MSFT, May 31 '18 at 07:53

C# Generate Azure Table Storage ConnectionString

2 Answers2

Linked