I’m migrating a project from version 9.2 to version 10. I am presenting the following errors in the Scripts, how can I fix them ?
Attached image of the errors
Regarding the warning: we are now supporting async methods, and non-async ones are slowly getting deprecated - however most of them still work including the SelectCommand().
Regarding the errors, you need to import each external dll to your solution on Expressions / References, like the screenshot below:
Just make sure you are using the correct dll to the right target framework.
I would also like to mention that System.Data.SqlClient is now deprecated, and Microsoft.Data.SqlClient is its sucessor.
This is because your UI is currently filtered to show only basic features.
Follow the highlighted steps to show all modules and features:
Thanks for the answer, what version of dll should be used in FrameworX, I am trying to reference the “Microsoft.Data.SqlClient.dll” of version 6.1.25, but apparently it is generating an error.
Before we keep going to this direction, why exactly are you using Scripts to manage an SQL connection over using the built-in connector in Datasets / DBs?
Yes, we decided to use some direct commands, because in some things we could not adapt it with the tools that frameworkX has. Yes we are using the integrated connection in some sections of our development, but in the sections where we could not adapt this tool we decided to use .Net programming.
I’m still investigating how to use this dll as well, I’m probably missing a dependency or something.
In the meanwhile, you can still use the old System.Data.SqlClient - just make sure you use the .netstandard2.0 target framework if it’s a windows-only application.