Knowledge Base for IT Professionals, Teachers and Astronauts
The C# Setup.msi installer can take an argument, TARGETDIR to set the install location of the application. If the application is already installed on the computer, and we try to change the install location without first uninstalling it, the installer ignores the value in the TARGETDIR property. To be able to install the application at …
Continue reading “TARGETDIR property is ignored during application install”
Windows scheduled tasks are used to automatically execute processes on a set schedule. To allow a long running process to continue, even if the scheduled task would start it again before the process completion, we need to uncheck the “If the running task does not end when requested, force it to stop” option. When we …
To be able to create, edit, and test MSSQL SSIS package solutions in Visual Studio Community edition we need to install the SQL Server Data Tools under Data storage and processing in the list of workloads. Creating SQL Server Integration Services (SSIS) projects SSIS extension download locations Installation See Integration Services (SSIS) Projects and Solutions for more information
When a C# project moved from an earlier version of Visual Studio to Visual Studio 2022, AOT (Ahead Of Time) publish starts to fail with the error message RuntimeIdentifier is required for native compilation. Try running dotnet publish with the -r option value specified. This is cuased by old settings in the project. To eliminate …
To use command line arguments during debugging in Visual Studio Community Edition we will create project profiles. Create the project profile Select the project profile To debug the application with a specific project profile
Visual Studio Community Edition is a free, popular IDE to develop C# business applications. AI assistance can enhance the development process and do the boilerplate creation. As of writing, the most popular free extension that supports multiple AI models is Comment2GPT by Merry Yellow. Installation For more information visit the Comment2GPT Visual Studio Marketplace page …
Continue reading “Comment2GPT AI extension in Visual Studio for multiple models”
When the .NET Entity Framework retrieves data from the database and parses it into the structure that we specify in our code, we have to make sure nullable columns are modeled with nullable properties in our code. When null values are retrieved and the structure in the code does not allow null value in any …
Continue reading “Data is Null. This method or property cannot be called on Null values.”
Standalone Windows executables are compiled ahead of time (AOT) and distributed as three executable files (.exe, .dll, .runtimeconfig.json). This format is ideal for small executables called from the command line or from other applications. To create an AOT Windows executable in Visual Studio 2022 or later Start a new project Build the executable Prerequisites To …
Continue reading “Build a standalone Windows executable in Visual Studio”
In this post we will develop a .NET 8 console application which reads the configuration values from environment variables. This enables us deploy the application in an EKS cluster and read the config values from any secure secret storage. The develoment environment Docker configuration To prevent Visual Studio from debugging in Docker containers Debugging in …
Continue reading “Developing a secure .NET 8 (core) console application”
Visual Studio Community Edition has all the features for MSSQL SSIS package development. We need to download the SQL Server Integration Services Projects extension. In the package properties set DelayValidation to True to avoid long wait when opening the package.