c# - 使用事务内存数据库进行单元测试时，如何抑制 InMemoryEventId.TransactionIgnoredWarning？

Question

我正在使用 EF Core 内存数据库，并尝试对使用事务的方法运行单元测试:

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

    // some other stuff

    transaction.Commit();
}

但是，我从测试运行程序中收到此错误:

System.InvalidOperationException: Warning as error exception forwarning 'InMemoryEventId.TransactionIgnoredWarning': Transactions arenot supported by the in-memory store. Seehttp://go.microsoft.com/fwlink/?LinkId=800142 To suppress thisException use the DbContextOptionsBuilder.ConfigureWarnings API.ConfigureWarnings can be used when overriding theDbContext.OnConfiguring method or using AddDbContext on theapplication service provider.

如何抑制该错误？

Answer 1

在声明内存数据库的代码中，配置上下文以忽略该错误，如下所示:

public MyDbContext GetContextWithInMemoryDb()
{
    var options = new DbContextOptionsBuilder<MyDbContext>()
        .UseInMemoryDatabase(Guid.NewGuid().ToString())
        // don't raise the error warning us that the in memory db doesn't support transactions
        .ConfigureWarnings(x => x.Ignore(InMemoryEventId.TransactionIgnoredWarning))
        .Options;

    return new MyDbContext(options); 
}