public async Task AddAsyncTest_ShouldContainNewProduct() { _configuration = new ConfigurationBuilder().Build(); var options = new DbContextOptionsBuilder <NorthWeirdDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .EnableSensitiveDataLogging() .Options; using (var context = new NorthWeirdDbContext(options)) { var service = new SqlProductData(context, _configuration, _mapper); var productToAdd = new ProductDto { ProductName = "Lososij", ProductId = 4 }; await service.AddAsync(productToAdd); } using (var context = new NorthWeirdDbContext(options)) { var product = context.Products.First(); Assert.AreEqual(1, context.Products.Count()); Assert.AreEqual(4, product.ProductId); Assert.AreEqual("Lososij", product.ProductName); } }
public SqlProductData( NorthWeirdDbContext context, IConfiguration configuration, IMapper mapper ) { _context = context; _configuration = configuration; _mapper = mapper; }
public static NorthWeirdDbContext Create() { var options = new DbContextOptionsBuilder <NorthWeirdDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .EnableSensitiveDataLogging() .Options; var context = new NorthWeirdDbContext(options); context.Database.EnsureCreated(); context.Suppliers.AddRange(new List <Supplier> { new Supplier { SupplierId = 1, CompanyName = "Dumpling boutique" }, new Supplier { SupplierId = 2, CompanyName = "Washington Bread Factory №2" }, new Supplier { SupplierId = 3, CompanyName = "Alaska fishing inс" } }); context.Categories.AddRange(new List <Category> { new Category { CategoryId = 1, CategoryName = "Fish" }, new Category { CategoryId = 2, CategoryName = "Meat" }, new Category { CategoryId = 3, CategoryName = "Vegetables" } }); context.Products.AddRange(new List <Product> { new Product { ProductId = 1, ProductName = "Frutella", CategoryId = 1, SupplierId = 1 }, new Product { ProductId = 2, ProductName = "Mars", CategoryId = 2, SupplierId = 2 }, new Product { ProductId = 3, ProductName = "Onion", CategoryId = 3, SupplierId = 3 } }); context.SaveChanges(); return(context); }
public static void Destroy(NorthWeirdDbContext context) { context.Database.EnsureDeleted(); context.Dispose(); }
public void Setup() { _context = NorthWeirdDbContextFactory.Create(); _mapper = new MapperConfiguration(c => c.AddMaps(typeof(ProductMappingProfile))).CreateMapper(); }
public SqlSupplierData(NorthWeirdDbContext context, IMapper mapper) { _context = context; _mapper = mapper; }
public SqlCategoryData(NorthWeirdDbContext context, IMapper mapper) { _context = context; _mapper = mapper; }