Mocking Entity Framework Core context c# entity-framework entity-framework-core


I try to test my app so I need to mock my EF context.

My code seems to be ok, but I have following exception:

"System.ArgumentNullException : Value cannot be null. Parameter name: source"

Here is my test method:

  var options = new DbContextOptionsBuilder<ProductContext>().Options;
    var settings = new SqlSettings
        InMemory = true

    var context = new Mock<ProductContext>(options, settings);
    var mockTreeService = new TreeService(context.Object);
    await mockTreeService.CreateTreeAsync("Testing tree", Guid.NewGuid());

    context.Verify(x => x.AddAsync(It.IsAny<Tree>(), CancellationToken.None), Times.Once);

It looks like that this exception is thrown during executing this piece of code

            var tree = await _context.Trees
                .Include(x => x.Translation)
                .FirstOrDefaultAsync(x => x.Translation.Pl == name);

It comes from my service which I'm testing

3/28/2019 8:53:59 PM

Accepted Answer

I think this is due to not having a connection string set. Frankly, it's a bit difficult to fully mock out DbContext, which is why the EF Core team has provided an in-memory implementation. This is far easier to work with for testing purposes. Just change your options initialization to:

var options = new DbContextOptionsBuilder<ProductContext>()

Afterwards, you'll need to populate the database with your test data. Then, you can run the rest of your test.

Note: if you're using the in-memory database, you don't need to mock the context anymore, so you can remove that bit of code. The in-memory database is essentially, itself, a mock.

11/29/2017 2:17:43 PM

Popular Answer

I have used this library. Very easy and can write unit test using less coding.

You can use most of Moq methods if you are using moq framework.

Below is example code for test DBQuerys.

public async Task<Boat> GetByIdAsync(string id)
    => await _boatContext.Boats.Where(x => == id).FirstOrDefaultAsync();

public async Task GetByIdAsync_WhenCalled_ReturnsItem()
    // Arrange
    var models = new[] { new Boat { id = "p1" } };
    var dbContextMock = new DbContextMock<BoatContext>();
    dbContextMock.CreateDbQueryMock(x => x.Boats, models);

    var service = new Properties(dbContextMock.Object);

    // Act
    var okResult = await service.GetByIdAsync("p1");

    // Assert

Posting here this may help someone :)

Related Questions


Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow