I recently got a brand new workstation and installed VS2019 on it. Previously, I was on VS2017 and working with db unit test project. Now when building our SQL Server database unit test project in VS2019, I got the following error:
The primary reference "Microsoft.Data.Tools.Schema.Sql.UnitTesting, Version=16.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" could not be resolved because it has an indirect dependency on the assembly "Microsoft.Build, Version=15.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which was built against the ".NETFramework,Version=v4.7.2" framework. This is a higher version than the currently targeted framework ".NETFramework,Version=v4.6.1".
And when I open db unit test design file, its showing black screen instead of the scripts window.
So do I need to downgrade the version of MSBuild or any other options to resolve this?