Integration test cases with DB project
advanced
I'm currently building integration tests using xUnit and Testcontainers. We use Dapper and the way we handle migrations is not exactly standard. We have a database project and there's a MSBuild PreBuildEvent that keeps track of which migrations have been applied to the DB. Once the DB project builds, it produces a .dacpac file that can then be deployed easily either through CD or manually through SSMS via Upgrade Data-Tier Application. So I can easily spin up a SQL Server container using Testcontainers, but then how do I apply the migrations? Somehow build the DB project from the integration test project and deploy the .dacpac?
