We are a group of humble, but amazing developers with one thing in common: we're all west of somewhere else.Where we differ from similar sites: we talk to each other! Often. At conferences, via email, and on Slack. From Docker to Canadian politics to feature toggles to smoked meat, we're never at a loss for words. We blog, talk, write, and present. Thanks for stopping by.
One of the most common pain points of implementing automated acceptance testing is the interaction with the database.
For greenfield projects you can plan from day one how to setup the test to easily include the database interaction but with legacy projects it is not always that easy.
Entity Framework Core makes it easy to write tests that execute against an in-memory store but sometimes we want to actually run our tests against a real relational database. In this post, we look at how to create an integration test that runs against a real SQL Server database.