Long did I hold this perception that integration tests are hard. With EF core, they are actually really easy. Instead of using SQL Sever, we can substitute with LocalDB. Run this before running the tests and you'll have your db setup. After calling
EnsureCreated you can add things into the database.
public static DataContext Create()
var options = new DbContextOptionsBuilder<DataContext>()
var context = new DataContext(options);
// ADD Test Data