public async Task Sqlite() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseSqlite("DataSource=:memory:") .Options; var dbContext = new AppDbContext(options); dbContext.Database.OpenConnection(); dbContext.Database.EnsureCreated(); var list = new List <Profile>() { new Profile() }; dbContext.Profile.AddRange(list); dbContext.SaveChanges(); var controller = new Lab05Controller(dbContext); var result = await controller.Index1() as OkObjectResult; result.Value.As <List <Profile> >().Should().BeEquivalentTo(list); dbContext.Database.EnsureDeleted(); dbContext.Database.CloseConnection(); }
public async Task Insert() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .Options; var dbContext = new AppDbContext(options); var controller = new Lab05Controller(dbContext); await controller.Index2(new ProfileDto() { Name = "Test" }); var profile = await dbContext.Profile.FirstAsync(); profile.Name.Should().Be("Test"); }
public async Task Add() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .Options; var dbContext = new AppDbContext(options); var list = new List <Profile>() { new Profile() }; dbContext.Profile.AddRange(list); dbContext.SaveChanges(); var controller = new Lab05Controller(dbContext); var actual = await controller.Index1(); var result = actual as OkObjectResult; result.Value.As <List <Profile> >().Should().BeEquivalentTo(list); }