The way of storage table second endpoint constructed in Azure SDK for net doesn't support use in Azurite

[zzhxiaofeng]

Error Description:
Azurite is an Azure Storage emulator.
Current storage table second endpoint which is constructed in Azure SDK for net can not access Azurite. The reason is the storage table second endpoint for Azurite is different from the one of an Azure storage account.
In Azurite, storage table second endpoint constructed is shown as following:

https://127.0.0.1:10002/<account-name>-secondary/<resource-path>

In Azure SDK for net, storage table second endpoint constructed is shown as following:

https://<account-name>-secondary.table.core.windows.net/<resource-path>

Error Track:
The code for storage table second endpoint constructed in Azure SDK for net is here

Expected Behavior
Storage table second endpoint which is constructed in azure sdk for net can access azurite.

@jongio for notification.

[jsquire]

@christothes: I'm not sure if this falls in the scope of the client library or should be routed to the Storage service team. Would you mind offering your thoughts?

[christothes]

@zzhxiaofeng Please take a look at #17246 and validate if this approach resolves the issue.

[pakrym]

@zzhxiaofeng is there any benefit to having a secondary endpoint for azurite? Do you see a downside to always using the primary one for the loopback

[zzhxiaofeng]

@christothes Yes, the issue has been resolved. thank you.

[zzhxiaofeng]

@pakrym I just think using secondary endpoint for Azurite when the primary one becomes unavailable.