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
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
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
Error: Failed to find a valid digest in the ‘integrity’ attribute for resource xxxxxx. The resource has been blocked. Resolution: This is an annoying issue indeed and I’m getting that error every now and then. It seems to happen after updating some packages, and the build processes fails to pick up the new SHA for... » read more
Error: Error in Visual Studio when trying to publish project. Event name should have at least 3 parts separated by slash Fix: This specific error happens when you are not logged in to the Azure account in VS (the account that contains the Function app). To work-around this issue: You can go to File ->... » read more
Key Action F5 Build Crtl + K + C Comment Line Crtl + K + U Uncomment Line Crtl + M + O Collapse All Crtl + Scroll Up Zoom In Ctrl + Scroll Down Zoom Out Printable Sheet Click to get our printable keyboard shortcut cheatsheet for Visual Studio Sources: https://docs.microsoft.com/en-us/visualstudio/ide/default-keyboard-shortcuts-in-visual-studio?view=vs-2019
Error: Project reference not found in Visual Studio with multiple projects. Resolution: Make sure all projects in the solutions have the same .NET Framework version.
File Location (For Local Development Environment) C:\Users\user01\AppData\Roaming\Microsoft\UserSecrets\e13a4f3c-0111-4fcc-bba1-11d7e67a1b6d\secrets.json Example Note: Need to create the same entry in configuration when deploying application to Azure. Each project will have a user secret file. Change the name of the project will create a new user secret file.