我正在尝试搭建我的测试环境,但Sqlite适配器出现了问题。每个创建的上下文都具有相同的连接,因此内存数据库应该为每个上下文正确构建。
但是当我尝试添加新内容时,它会抛出错误:“没有这样的表:% here_is_my_tablename%”。
我认为我的配置应该是好的。
Base:
public abstract class BaseServiceTests : IDisposable
{
protected readonly SqliteConnection Connection;
public BaseServiceTests()
{
Connection = new SqliteConnection("DataSource=:memory:");
Connection.Open();
Assert.NotNull(Connection);
using (var ctx = BuildCoreContext())
{
ctx.Database.EnsureCreated();
}
using (var ctx = BuildWebContext())
{
ctx.Database.EnsureCreated();
}
}
public void Dispose()
{
Connection.Close();
}
public DbContextOptions<TContext> Options<TContext>() where TContext: DbContext
{
var options = new DbContextOptionsBuilder<TContext>()
.UseSqlite(Connection)
.Options;
return options;
}
public ServiceRequestCoreContext BuildCoreContext()
{
var ctx = new ServiceRequestCoreContext(Options<ServiceRequestCoreContext>(), null);
ctx.Database.OpenConnection();
return ctx;
}
public ServiceRequestWebContext BuildWebContext()
{
var ctx = new ServiceRequestWebContext(Options<ServiceRequestWebContext>(), null);
ctx.Database.OpenConnection();
return ctx;
}
}
测试
public class RequestServiceTests : BaseServiceTests
{
public async Task Prepare()
{
using (var ctx = BuildCoreContext())
{
await ctx.RequestTypes.AddAsync(new RequestType((int)RequestTypes.Order, "TestType - test"));
await ctx.RequestStatuses.AddAsync(new RequestStatus((int)RequestStatuses.AcceptedForVeryfication, "test - test", "test - test"));
await ctx.Companies.AddAsync(new CustomerCompany(1, "test - test", "Test - test"));
await ctx.SaveChangesAsync();
}
}
[Fact]
public async Task when_creating_new_request_it_should_not_be_null()
{
//Arrange
await Prepare();
var customerId = 1;
var iGen = new IdentifyGenerator();
//Act
using (var webCtx = BuildWebContext())
{
webCtx.Database.OpenConnection();
var service = new RequestService(webCtx, BuildCoreContext(), iGen);
await service.CreateAsync(customerId);
await webCtx.SaveChangesAsync();
}
//Assert
using (var ctx = BuildWebContext())
{
ctx.ServiceRequests.Should().HaveCount(1);
ctx.ServiceRequests.FirstOrDefault().Should().NotBeNull();
}
}
}
"DataSource=file::memory:?cache=shared"
。 - Shahin Dohan