I have a database project in Visual Studio 2019 that references another database. I have added a dacpac and use a variable to reference that database.
This works great, until it comes to unit tests. I have added a unit test project, but the Unit Test project doesn't perform the variable substitution - it says the object [$(db)]... is undefined.
How can I unit test with database variables?