WebApplicationFactory does not properly configure the services, as although the In Memory SQL provider is set, the tests are still usings the one from the Startup class, in this case the SQL Provider.
The code follows the ASP.NET docs, so there is no variation from the example in docs.