Access in memory dbcontext in integration test

Question

How can I access the dbcontext of an in memory database inside an integration test?

I have followed the code here: https://docs.microsoft.com/en-us/aspnet/core/test/integration-tests?view=aspnetcore-2.2#customize-webapplicationfactory

and have a similar test to:

public class IndexPageTests : 
    IClassFixture<CustomWebApplicationFactory<RazorPagesProject.Startup>>
{
    private readonly HttpClient _client;
    private readonly CustomWebApplicationFactory<RazorPagesProject.Startup> 
        _factory;

    public IndexPageTests(
        CustomWebApplicationFactory<RazorPagesProject.Startup> factory)
    {
        _factory = factory;
        _client = factory.CreateClient(new WebApplicationFactoryClientOptions
            {
                AllowAutoRedirect = false
            });
    }

In this IndexPageTests is it possible to access the in-memory dbcontext?

I have tried

 using (var context = new ApplicationDbContext(???))

I need to access data from tables i had previously seeded from CustomWebApplicationFactory

but not sure what to put for the options

You would have to resolve it via the host's services provider. factory.Server.Host.Services.GetService<ApplicationDbContext>() — Nkosi
@Nkosi, this gives error : Cannot resolve scoped service 'ApplicationDbContext' from root provider. — raklos
@Nikosi, thanks you pointed me in the right direction... had to create scope first _factory.Server.Host.Services.GetService<IServiceScopeFactory>(); — raklos
Glad to help. You should add it as a self answer so that others can benefit. — Nkosi

raklos raklos · Accepted Answer · 2019-03-07T23:41:00

Thanks to Nikosi, this is the way I managed to get the dbcontext

var scopeFactory = _factory.Server.Host.Services.GetService<IServiceScopeFactory>();
using (var scope = scopeFactory.CreateScope())
{
   var context = scope.ServiceProvider.GetService<ApplicationDbContext>();
}

Access in memory dbcontext in integration test

2 Answers