Vertigis Studio Workflow Server side Custom Activity with Sql server connection
Hi All,
I am currently using Microsoft.EntityFrameworkCore.SqlServer 6.0.33 nuget for connecting to sql server. However I got kept on getting error Strings.PlatformNotSupported_DataSqlClient from Microsoft.Data.SqlClient. I checked the workflow studio and I noticed it is not using “microsoft.data.sqlclient”, it is using the “System.data.sqlclient” .
Does anyone has idea for entityframework core sql server to use in VertiGIS studio Workflow.
I am using latest workflow version 5.41.0
Current EntityFramework, EntityFramework.SqlServer 6.44 in VertiGIS studio Workflow are already obsolete and Microsoft.EntityFramework.SqlServer is introduced.
Thanks and best Regards,
Than
-
Hi Than Aung ,
Thanks for your question.
You might need to treat Microsoft.EntityFrameworkCore.SqlServer and Microsoft.Data.SqlClient as external references according to this article. If they're not currently used by Workflow Server, you'll need to copy them to the “C:\Program Files\VertiGIS\VertiGIS Studio Workflow\CustomAssemblies” directory (assuming you chose the default installation location) along with your activity pack.
That should get you unstuck in the short term.
In the long term, I can migrate us from System.Data.SQLClient to Microsoft.Data.SqlClient in a future release.
1 -
Thanks Ken,
Yes, I have followed the article you mentioned, and it successfully copied all the referenced DLLs into the custom assemblies folder. But it is not working.
I tried and modified the application design to use a .NET Standard 2.1 library, with direct references to EF 6.4, EF 6 SQL Server (which is no longer supported by Microsoft) to VertiGIS and the System.Data.SqlClient NuGet package. This setup is working well.
However, I would like to transition this application to .NET Core.
Any guidance on how to achieve this would be greatly appreciated!
Best Regards,
Than
0 -
Hi Than Aung ,
I think you should be able to use .NET Core, although I don't know if I've tried that for an activity pack. I can tell you that Workflow Server itself is currently targetting .NET 8.0. You should probably match that for the best chance of it working.
0
Please sign in to leave a comment.
Comments
3 comments