如何通过Azure订阅ID与API密钥生成Table Storage连接字符串？

First off, let's clarify a key point: you can't generate a valid Table Storage connection string with just a subscription ID and an "Azure API Key"—you're missing a critical piece of information: your Storage Account Name. Connection strings are tied directly to individual storage accounts, not your entire Azure subscription.

Required Information #

To build a valid connection string, you'll need:

• Your Storage Account Name (this is unique to your storage resource in Azure)
• Your Storage Account Access Key (this is the key associated with your storage account, not a subscription-level API key)
• (Optional) The endpoint suffix (defaults to core.windows.net for public Azure regions)

Connection String Format #

The standard connection string for Table Storage (using account keys) follows this structure:

DefaultEndpointsProtocol=https;AccountName=<your-storage-account-name>;AccountKey=<your-access-key>;EndpointSuffix=core.windows.net

If you want to explicitly specify the Table Storage endpoint, you can also use this format:

DefaultEndpointsProtocol=https;TableEndpoint=https://<account-name>.table.core.windows.net/;AccountName=<account-name>;AccountKey=<access-key>

Implementing in .NET Libraries #

How you handle this depends on which Azure SDK library you're using:

1. Legacy WindowsAzure.Storage Library

If you're using the older WindowsAzure.Storage package, you can use the CloudStorageAccount class to construct the connection string programmatically:

using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Table;

// Replace with your actual values
string storageAccountName = "your-storage-account-name";
string storageAccountKey = "your-storage-account-access-key";

// Create credentials and storage account object
StorageCredentials credentials = new StorageCredentials(storageAccountName, storageAccountKey);
CloudStorageAccount storageAccount = new CloudStorageAccount(credentials, useHttps: true);

// Retrieve the formatted connection string
string connectionString = storageAccount.ToString(true);

2. Modern Azure.Data.Tables Library

The newer Azure.Data.Tables SDK doesn't include a dedicated method to generate connection strings, but you can either:

• Directly initialize a client using credentials without building a connection string, or
• Manually construct the connection string using the standard format

Here's how both approaches look:

using Azure.Data.Tables;
using Azure.Storage;

// Replace with your actual values
string storageAccountName = "your-storage-account-name";
string storageAccountKey = "your-storage-account-access-key";

// Option 1: Initialize client without connection string
StorageSharedKeyCredential credential = new StorageSharedKeyCredential(storageAccountName, storageAccountKey);
TableServiceClient tableClient = new TableServiceClient(
    new Uri($"https://{storageAccountName}.table.core.windows.net/"),
    credential);

// Option 2: Manually build connection string and use it
string connectionString = $"DefaultEndpointsProtocol=https;AccountName={storageAccountName};AccountKey={storageAccountKey};EndpointSuffix=core.windows.net";
TableServiceClient clientFromConnString = new TableServiceClient(connectionString);

Important Note #

Your Azure subscription ID is used for managing Azure resources (like creating/deleting storage accounts) but isn't part of the storage connection string. The "Azure API Key" you mentioned should be the access key specific to your storage account—you can find this in the Azure Portal under your storage account's Access Keys blade.

内容的提问来源于stack exchange，提问作者David Maisuradze