What are the alternatives to list all tables in Azure Storage Account since Microsoft.WindowsAzure.Storage is now depecrated

Question

What are the alternatives to list all tables in Azure Storage Account since Microsoft.WindowsAzure.Storage is now depecrated

FlyingInCloud 21

Using Microsoft.WindowsAzure.Storage we can list all tables in a Storage Account easily like this:

    string storageConnectionString = Environment.GetEnvironmentVariable("StorageConnectionString");
    CloudStorageAccount storageAccount = CloudStorageAccount.Parse(storageConnectionString);
    CloudTableClient tableClient = storageAccount.CreateCloudTableClient();

    List

Sumarigo-MSFT 47,516 Reputation points Microsoft Employee

2023-01-31T08:38:33.06+00:00

@FlyingInCloud Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sumarigo-MSFT 47,516 Reputation points Microsoft Employee

2023-02-05T14:32:39.6533333+00:00

@FlyingInCloud Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

2 answers

Your answer

Sumarigo-MSFT 47,516 Reputation points Microsoft Employee

2023-01-31T08:38:33.06+00:00

@FlyingInCloud Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sumarigo-MSFT 47,516 Reputation points Microsoft Employee

2023-02-05T14:32:39.6533333+00:00

@FlyingInCloud Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Michael Taylor 57,216

I don't use ATS but I believe the equivalent code is available in [TableServiceClient.Query](https://learn.microsoft.com/en-us/dotnet/api/azure.data.tables.tableserviceclient.query?view=azure-dotnet which is defined in the Azure.Data.Tables package of the Azure SDK for .NET library. It supposedly handles Cosmos and Storage Account tables.

Answer 2

Sumarigo-MSFT 47,516 Microsoft Employee

@FlyingInCloud Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

I’d use the latest SDK and leverage the following. It should provide you with the same functionality, at least based on the below?

TableServiceClient.QueryAsyncMethod (Azure.Data.Tables) - Azure for .NET Developers | Microsoft Learn

Please let us know if you have any further queries. I’m happy to assist you further.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

FlyingInCloud 21 Reputation points

2023-01-23T08:59:03.05+00:00

Can you provide a working example with the said method? I am having troubles on the Linq expression part because what I want is to retrieve the list of the tables and delete its entities afterwards. Thank you
Sumarigo-MSFT 47,516 Reputation points Microsoft Employee

2023-02-01T04:59:46.25+00:00

@FlyingInCloud I’m checking on this internally with the product team and will get back to you with something concrete. Apologies for the delay in responding here,

In meanwhile can you share your code snippet of the approach you are trying which doesn’t work?
Sumarigo-MSFT 47,516 Reputation points Microsoft Employee

2023-02-08T09:33:01.83+00:00

@FlyingInCloud csharp sample code to Query and List all the Tables win the Azure Storage Account.
can you share your code snippet of the approach you are trying which doesn’t work?

Share via

What are the alternatives to list all tables in Azure Storage Account since Microsoft.WindowsAzure.Storage is now depecrated

2 answers

Your answer