Xunit and database projects
I'm trying to write some integration tests and am having a little trouble setting up the database. I have imported my database as a SQL Server project to my solution and added a project reference from my test project to the database project. I expected that would place the dacpac in the test project's build output directory, but that's not the case. The dacpac is in the database project's build output directory, but only a dll and pdb in the test project's.
I need the path to the dacpac so I can programmatically deploy it to the test environment when tests run. Seems to me I should be able to get it in the test project's output directory, but if there is another/a better way to do this, please lmk!
I need the path to the dacpac so I can programmatically deploy it to the test environment when tests run. Seems to me I should be able to get it in the test project's output directory, but if there is another/a better way to do this, please lmk!
