public void AddCustomer_Database_test() { // arrange using var connection = new SqliteConnection("Data Source=:memory:"); connection.Open(); var options = new DbContextOptionsBuilder <StoreAppDbContext>().UseSqlite(connection).Options; var customer = new Customer { Id = 1, FirstName = "Jerry", LastName = "Smith", Email = "*****@*****.**" }; // act using (var context = new StoreAppDbContext(options)) { context.Database.EnsureCreated(); var repo = new StoreRepository(context, new NullLogger <StoreRepository>()); repo.AddCustomer(customer); } //assert using var context2 = new StoreAppDbContext(options); CustomerEntity customerActual = context2.Customers .Single(l => l.FirstName == "Jerry"); Assert.Equal(customer.FirstName, customerActual.FirstName); }
public void AddProduct_Database_test() { // arrange using var connection = new SqliteConnection("Data Source=:memory:"); connection.Open(); var options = new DbContextOptionsBuilder <StoreAppDbContext>().UseSqlite(connection).Options; var product = new Product { Id = 1, Name = "Walmart", Price = 5 }; // act using (var context = new StoreAppDbContext(options)) { context.Database.EnsureCreated(); var repo = new StoreRepository(context, new NullLogger <StoreRepository>()); repo.AddProduct(product); } //assert using var context2 = new StoreAppDbContext(options); ProductEntity productActual = context2.Products .Single(l => l.Name == "Walmart"); Assert.Equal(product.Name, productActual.Name); }
public void AddLocation_Database_Test() { // arrange using var connection = new SqliteConnection("Data Source=:memory:"); connection.Open(); var options = new DbContextOptionsBuilder <StoreAppDbContext>().UseSqlite(connection).Options; var location = new Location { Id = 1, Name = "Walmart" }; // act using (var context = new StoreAppDbContext(options)) { context.Database.EnsureCreated(); var repo = new StoreRepository(context, new NullLogger <StoreRepository>()); repo.AddLocation(location); } //assert using var context2 = new StoreAppDbContext(options); LocationEntity customerActual = context2.Locations .Single(l => l.Name == "Walmart"); Assert.Equal(location.Name, customerActual.Name); }
private ProductRepository GetInMemoryProductRepository() { DbContextOptions <StoreAppDbContext> options; var builder = new DbContextOptionsBuilder <StoreAppDbContext>(); builder.UseInMemoryDatabase("InMemoryProductTestDB"); options = builder.Options; StoreAppDbContext context = new StoreAppDbContext(options); context.Database.EnsureDeleted(); context.Database.EnsureCreated(); return(new ProductRepository(context)); }
public UserRepository(StoreAppDbContext context) { _context = context; }
public StoreRepository(StoreAppDbContext context, ILogger <StoreRepository> logger) { _context = context ?? throw new ArgumentNullException(); _logger = logger ?? throw new ArgumentNullException(); }