title: How to create a dummy database for functional tests in .NET Core?
body: <p>My app is built on .NET Core with Entity Framework 6. There are some complex C# LINQ queries that I am making against the db context. While I have XUnit unit tests that mock up the db and check the query results, I've found the behaviour is not always the same. How can I write tests that create some sort of a relational dummy db that would behave exactly as the real db, seed the db, execute and test the results of the query and then delete/tear down the db? I haven't been able to find something. There are some articles that recommend creating a local db separately, but I would like a technique that does everything including db creation and deletion as part of my testing suite.</p>