The SQL Server extension for Visual Studio Code is a nice way of avoiding SQL Server Management Studio for when you need to do some light SQL’ing while working in VS Code
You can do queries directly from VS Code even with awesome intellisense and nice formatting.
VS Code is getting closer and closer to becoming a one-stop destination for all the things we need to with NAV and Business Central.
Sorry for the click-bait title. But I have just tried out the new developer preview on one of our (Currently) C/Side ExtensionV1 based products. This article is not really about that, but about one of the positive side effects of going through the process.
First disclaimer: This product already compiles to an ExtensionV1 and is CfMD certified, so of cause it is perfect 🙂
But the new compiler and the TXT2AL transformation tool will find things that can be improved, let me show you some of the results I got:
Properties not used on actions
RunPageMode is only valid if you have a RunObject also:
Since I use OnAction() RunPageMode does not do anything.
DecimalPlaces on non-decimal fields
BlankZero on non-number fields.
C/Side accepts wrong Indention
You can place ActionGroups outside ActionContainers.
Assignment of FlowFields
C/Side accepts this, and ignores it; the new compiler gives an error.
Wrong keys on Actions
In multiple places, you can specify sortings, and C/Side happily accepts “Field###” – Extensions don’t.
There are many more things that this process can catch, but these examples were some I encountered.
You can improve the code quality of your existing solution by running it through the TXT2AL and the new compiler. And when you’re ready to jump to ExtensionV2, the jump will be easier and smaller.
Finally Extensions V2 supports DotNet (At least in the Developer Preview.
But as soon as you fire this up, perhaps with the help of TXT2AL, you’re met with assemblies not resolved. Both assemblies from standard DotNet (from the global assembly cache) and standard NAV DLLs.
There is a setting in Visual Studio Code (In User Settings Ctrl+Comma) called al.assemblyProbingPaths that specifies where Code will search for DotNet assemblies (Also called DLL files). Add the Global Assembly Cache and the add-ins folder from a NAV installation to resolve all the references:
"C:/Program Files/Microsoft Dynamics NAV/110/Service/Add-ins"
Restart Visual Studio Code and everthing should work 🙂