How to suppress InMemoryEventId.TransactionIgnoredWarning when unit testing with in-memory database with transactions?

user_1879019 0
Viewed 11522

I'm using an EF Core in-memory database and I'm trying to run a unit test on a method that uses transactions:

using (var transaction = await _context.Database.BeginTransactionAsync())
{
    _context.Update(item);
    result = await _context.SaveChangesAsync();

    // some other stuff

    transaction.Commit();
}

However, I'm getting this error from the test runner:

System.InvalidOperationException: Warning as error exception for warning 'InMemoryEventId.TransactionIgnoredWarning': Transactions are not supported by the in-memory store. See http://go.microsoft.com/fwlink/?LinkId=800142 To suppress this Exception use the DbContextOptionsBuilder.ConfigureWarnings API. ConfigureWarnings can be used when overriding the DbContext.OnConfiguring method or using AddDbContext on the application service provider.

How do I suppress that error?

entity-framework-core asp.net-core in-memory-database c#
2 Answers

I used the answer from @tomRedox but varied it for use in an ASP.NET Core 2.0 startup.cs file.

services.AddDbContext<MyDbContext>(options =>
{
    options.UseInMemoryDatabase("TestDb");
    options.ConfigureWarnings(x => x.Ignore(InMemoryEventId.TransactionIgnoredWarning));
});
user_4422810
Related