Fix Sql Unit Test build failure in Azure Devops pipeline

Recently I have faced an issue when adding the SQL DB project and SQL Unit test project to my existing .net core solution. In my local machine I am able to build successfully but the build failed in Azure devops pipeline.

I got the below error when I build with .net core CLI.



 Error MSB4019: The imported project "C:\Program Files\dotnet\sdk\3.1.301\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found. Confirm that the expression in the Import declaration "C:\Program Files\dotnet\sdk\3.1.301\\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" is correct, and that the file exists on disk.

Some of the discussions mentioned that specifying the vs SSDT path will fix the issue. So i have unloaded the project and edited the paths as below.

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Microsoft\VisualStudio\v16.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets

But no luck with that also. Since my most of the projects are in the .net core version and these two SQL DB project and SQL Unit test project are in .net 4.5 and 4.72 versions. This is the reason to the failure. So I ended with changing the .net core cli task to VSbuild version 1 task.




I have disabled the .net core cli build task and added the VS build task.
This is my configuration for VSBuild task.



I hope this will help someone who is facing the same issue.

Comments

Post a Comment

Popular posts from this blog

Fix Cannot determine the organization name for this 'dev.azure.com' remote URL Issue Visual Studio 2019

Image
 Recently I got this error in Visual studio 2019 after an update.I am able to connect to the remote repository and clone but couldn't perform Fetch,Pull and Push. Restarting visual studio also wont give a fix for this. But finally managed to fix this by modifying some settings in the git plugin. Error :    Cannot determine the organization name for this ' dev.azure.com ' remote URL. Ensure the `credential.useHttpPath` configuration value is set, or set the organization name as the user in the remote URL '{org}@dev.azure.com'.   Fix : Go to Tools > Options > Source control > Git Global Settings Then modify the settings as shown as below : Reason For This Error : After the update,the Git plugin for visual studio also updated. Previous version of the Git plugin doesn't require these values to be set. But new version expect values for these settings.
Read more

How to call content page method from master page in ASP.NET

Image
hi,last week i had a problem with calling the content page methods from the masterpage.After spend lot of time with google finally i fond a solution for that.The solution is... In my case i have an ajax control toolkit html editor in my master page.When content loaded to the editor i have a method to trigger in master page.through that method i need to populate my content page.for populating content page i have a method in content page.but the problem is when the content is loaded i need to trigger the content page method.i dont know any other ways are available or not but my solution is first trigger the master page method and then trigger the content page method through that. my master page public partial class Falcons : System.Web.UI.MasterPage { protected void Page_Load(object sender, EventArgs e) { } //this is the method that will called from editor when content loaded protected void editor_content_load(object sender, EventArgs e...
Read more