I have been using the included AppService Unit Tests to test my custom AppServices and helper classes. This is great for verifying that my logic is sound at a low level.
I have been doing some reading, and it is easy enough to run the ASP.NET Core project on my local machine and run a Test Project that has Selenium WebDriver tests implemented. This would automate my UI test process nicely. The only problem is that running the ASP.NET Core project from command line still instructs it to use the Default connection string, which is a SQL Server LocalDB instance. To automate tests I would need to delete the LocalDB, re-create the LocalDB, and then run the Migrator before testing again. This is long and annoying.
I was wondering if anyone here might have any ideas on how to do an "in-memory" temporary database (like the one implemented for the Unit Tests), but for Selenium UI tests. Any ideas (or alternative approaches) are appreciated.