An error occurs when debugging a C# durable project created with "Netherite/MSSQL" durable storage type

[v-xinda]

OS: M1 (Ventura 13.2)
Build Version: 20230207.6
.NET Version: 7.0.100-rc.2.22477.23
Regression: Not a regression

Repro Steps:

1. Create and open a C# project with "Durable Function orchestrator" function and select "MSSQL" durable storage type.
2. F5 -> Select "Connect Azure SQL Database".
3. Check whether no error occurs.

Expect:
No error occurs.

Actual:
An error occurs.

Details in Output:

More Info:

1. This issue also reproduces for the C# project created with "Netherite" durable storage type.
2. This issue doesn't reproduce for the C# project created with "Azure Storage" durable storage type.
3. This issue doesn't reproduce on Windows and Linux.

[MicroFish91]

Really good catch. We probably won't be able to fix this completely yet, but this led me to finding a pretty important adjacent bug which I have a partial fix for coming soon 🙂

[MicroFish91]

Rest of the solution will likely be addressed by this: Azure/azure-functions-durable-extension#2392

[v-xinda]

Verified this issue using build 20230304.7, it doesn't reproduce for the .NET 6 .0 (LTS) project. 
But an error also occurs when debug a .NET 6.0 Isolated or .NET 7.0 Isolated project. The error details as below:

Details in Terminal window:

 *  Executing task: dotnet clean /property:GenerateFullPaths=true /consoleloggerparameters:NoSummary 

MSBuild version 17.5.0-preview-23061-01+040e2a90e for .NET
Build started 3/8/2023 10:21:19 AM.
     1>Project "/Users/azuretest/Desktop/cs7-m/cs7-m.csproj" on node 1 (Clean target(s)).
     1>_CleanFunctions:
         Removing directory "/Users/azuretest/Desktop/cs7-m/bin/Debug/net7.0/".
     1>Done Building Project "/Users/azuretest/Desktop/cs7-m/cs7-m.csproj" (Clean target(s)).
 *  Terminal will be reused by tasks, press any key to close it. 

 *  Executing task: dotnet build /property:GenerateFullPaths=true /consoleloggerparameters:NoSummary 

MSBuild version 17.5.0-preview-23061-01+040e2a90e for .NET
  Determining projects to restore...
  All projects are up-to-date for restore.
  cs7-m -> /Users/azuretest/Desktop/cs7-m/bin/Debug/net7.0/cs7-m.dll
  Determining projects to restore...
  Restored /var/folders/2x/1979vrcs01x3qnpksn4_m51w0000gn/T/ccqt3dsa.vjm/WorkerExtensions.csproj (in 7.21 sec).
  WorkerExtensions -> /var/folders/2x/1979vrcs01x3qnpksn4_m51w0000gn/T/ccqt3dsa.vjm/buildout/Microsoft.Azure.Functions.Worker.Extensions.dll
 *  Terminal will be reused by tasks, press any key to close it. 

 *  Executing task: func host start 


Azure Functions Core Tools
Core Tools Version:       4.0.5030 Commit hash: N/A  (64-bit)
Function Runtime Version: 4.15.2.20177

[2023-03-08T02:22:00.075Z] Found /Users/azuretest/Desktop/cs7-m/cs7-m.csproj. Using for user secrets file configuration.
[2023-03-08T02:22:09.134Z] A host error has occurred during startup operation '64661a2b-d577-4b49-87a5-e04c15cb1f8b'.
[2023-03-08T02:22:09.134Z] Grpc.Core: Error loading native library. Not found in any of the possible locations: /Users/azuretest/Desktop/cs7-m/bin/Debug/net7.0/.azurefunctions/libgrpc_csharp_ext.arm64.dylib,/Users/azuretest/Desktop/cs7-m/bin/Debug/net7.0/.azurefunctions/runtimes/osx-arm64/native/libgrpc_csharp_ext.arm64.dylib,/Users/azuretest/Desktop/cs7-m/bin/Debug/net7.0/.azurefunctions/../../runtimes/osx-arm64/native/libgrpc_csharp_ext.arm64.dylib.
Value cannot be null. (Parameter 'provider')

 *  The terminal process "/bin/bash '-c', 'func host start'" terminated with exit code: 1. 
 *  Terminal will be reused by tasks, press any key to close it.