UTF-8 Encoding Issue in Visual Studio

Issue: All – Visual Studio has an issue where it saves SQL files as UTF-8-BOM as default, which causes errors when concatenating for our DBAs.  Please follow the attached instructions to install the “Fix File Encoding” Extension for Visual Studio. This will fix the issue by saving your SQL files as UTF-8 (without BOM) by... » read more

Install .NET Workload wasm-tools

.NET workload wasm-tools .NET wordload wasm-tools-net6 Visual Studio -> Tools -> Command Line -> Developer Command Prompt Example: ********************************************************************** ** Visual Studio 2022 Developer Command Prompt v17.9.6 ** Copyright (c) 2022 Microsoft Corporation ********************************************************************** C:\Users\xxxxx\source\repos>dotnet workload list Installed Workload Id Manifest Version Installation Source --------------------------------------------------------------------- maui-windows 8.0.7/8.0.100 VS 17.9.34728.123 maccatalyst 17.2.8004/8.0.100 VS 17.9.34728.123 ios 17.2.8004/8.0.100... » read more

Visual Studio Unload Project From Solution

In Visual Studio, you can “Unload” project from a solution. It can be useful to unload a project from a solution while resolving circular dependencies between projects or conflicts with different versions of the .NET framework between projects. In Visual Studio, the “Unload Project” option allows you to temporarily remove a project from the solution... » read more

DevOps Visual Studio 2022 Local/Remote Branch code setup

Get Latest from Main Branch In “Git Changes” window, go to Local -> main branch Do a “Pull” to get latest changes from main branch. Switch and select Local -> user branch Hover over “main” branch, right click and select “Merge into Current Branch” Push Changes to Main Branch In “Git Changes” window, “Commit” all... » read more

Can’t determine project language from files

Error: Getting the following error when trying to run a project from Visual Studio… Can't determine project language from files Solutions: Might be missing local.settings.json file from the project folder. Copy the file from the original project. References: https://github.com/Azure/azure-functions-core-tools/issues/2050

The certificate chain was issued by an authority that is not trusted

Issue: Database Connection String: Encrypt=True;TrustServerCertificate=False If you recently upgraded your SQL Server Native Client 11.0 (Provider=SQLNCLI11) application to use Microsoft OLE DB Driver 19 for SQL Server (Provider=MSOLEDBSQL19), you might receive error messages that resemble the following messages: [Microsoft OLE DB Driver 19 for SQL Server]: Client unable to establish connection [Microsoft OLE DB Driver... » read more

Create Self-Signed Certificate

Open PowerShell as administrator Run the following command: C:\Users\user01> New-SelfSignedCertificate -Subject “CN=OrgCert1234” -CertStoreLocation “cert:\LocalMachine\My” Now, what we have to do is obtain the private key certificate file to be able to upload it to Azure: Press the windows key Type Manage Computer Certificates and press Enter Go to Personal (on the left), then Certificates Double-click on the... » read more

The “ZipDeployTask” task was not given a value for the required parameter “DeploymentPassword”.

Error: Get the following error when trying to Publish a Azure Function project to Azure site… The “ZipDeployTask” task was not given a value for the required parameter “DeploymentPassword”. Fix: 1. Right click my project and select Publish.2. Select the appropriate publishing profile.3. In the Summary section bellow select the “Edit Password” button (indicated by... » read more

VS Code (Visual Studio Code)

https://code.visualstudio.com/ Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, macOS and Linux. It comes with built-in support for JavaScript, TypeScript and Node.js and has a rich ecosystem of extensions for other languages and runtimes (such as C++, C#, Java, Python, PHP, Go,... » read more