DfMon for MSSQL storage provider as NuGet package

[mmajcica]

Hi all,

would it be possible to package the version for SQL as nuget package and publish it? Or maybe include the necessary in the main package and be able to activate a custom provider via a setting?

Thanks

[cgillum]

The MSSQL storage provider is already supported by the Durable Functions Monitor project. More information here: https://github.com/microsoft/DurableFunctionsMonitor/tree/main/custom-backends/mssql.

[mmajcica]

The MSSQL storage provider is already supported by the Durable Functions Monitor project. More information here: https://github.com/microsoft/DurableFunctionsMonitor/tree/main/custom-backends/mssql.

Indeed I do know it is available. But it is not deployable via a nuget package as standard dfm. It would be nice if this backend was also packaged and published to make deployment easier. In certain enterprises, other deployment methods (suggested in the documentation) are not viable.

[scale-tone]

@mmajcica , please, clarify whether you need the isolated version or the inproc version to be packed. Or both?

My guess is, since you only want to deploy that package (as a standalone instance), then isolated would be good enough, but please confirm.

[mmajcica]

@mmajcica , please, clarify whether you need the isolated version or the inproc version to be packed. Or both?

My guess is, since you only want to deploy that package (as a standalone instance), then isolated would be good enough, but please confirm.

It does not mater for me, whatever it is easier to you. The only thing is that the currently available/suggested deployment methods do not work for me as there are certain company wide policies that are preventing me to deploy it.
As we are using the DFM nuget package and that is working like a charm, it would be nice to have also this custom version with sql support so that we can finally move our durable functions to sql provider.

Thank you

[scale-tone]

@mmajcica , I just pushed DurableFunctionsMonitor.DotNetIsolated.MsSql/6.6.0-beta4, can I ask you to check if it works for your scenario?

It expects SQL connection string as DFM_SQL_CONNECTION_STRING setting.
You can use the same ARM template to deploy it.

[mmajcica]

@mmajcica , I just pushed DurableFunctionsMonitor.DotNetIsolated.MsSql/6.6.0-beta4, can I ask you to check if it works for your scenario?

It expects SQL connection string as DFM_SQL_CONNECTION_STRING setting. You can use the same ARM template to deploy it.

I will test it this week, thanks a ton for such quick solution.

[scale-tone]

Added in v6.7