Could not use Durable Entities with Azure functions .NET isolated worker and SQL Storage Provider

[vpalaparthy]

We are trying to use Azure Durable Entities with .Net Isolated + SQL storage provider. We are getting exceptions while using Entities indicating that Durable Entities are not supported with SQL backend configuration.

configurations:

host.json:

local.settings.json:

Exception:

code snippet:

Referenced this article Durable entities - Azure Functions | Microsoft Learn and came to an understanding that Durable Entities are supported in .Net isolated mode.

Also tried another below code snipped resulting in similar exception.

Exception:

[cgillum]

Duplicate of #205.

[cgillum]

Also, we've made an update to the documentation to help clarify that Durable Entities are not yet supported with the MSSQL backend when using .NET Isolated. Apologies for the confusion.

https://learn.microsoft.com/azure/azure-functions/durable/durable-functions-storage-providers#comparing-storage-providers