private void InitializeDatabase() { using (var dbConn = _dbConnectionFactory.GetOpenConnection()) { // Truncate Product Table and insert test data dbConn.Execute(SQL_DELETE_PRODUCT); dbConn.Execute(SQL_INSERT_PRODUCT, new[] { new { Id = new Guid("8f2e9176-35ee-4f0a-ae55-83023d2db1a3"), Name = "Samsung Galaxy S7", Description = "Newest mobile product from Samsung.", Price = 1024.99, DeliveryPrice = 16.99 }, new { Id = new Guid("de1287c0-4b15-4a7b-9d8a-dd21b3cafec3"), Name = "Apple iPhone 6S", Description = "Newest mobile product from Apple.", Price = 1299.99, DeliveryPrice = 15.99 } }); // Truncate ProductOption table and insert data dbConn.Execute(SQL_DELETE_PRODUCTOPTION); dbConn.Execute(SQL_INSERT_PRODUCTOPTION, new[] { new { Id = new Guid("0643ccf0-ab00-4862-b3c5-40e2731abcc9"), ProductId = new Guid("8f2e9176-35ee-4f0a-ae55-83023d2db1a3"), Name = "White", Description = "White Samsung Galaxy S7" }, new { Id = new Guid("a21d5777-a655-4020-b431-624bb331e9a2"), ProductId = new Guid("8f2e9176-35ee-4f0a-ae55-83023d2db1a3"), Name = "Black", Description = "Black Samsung Galaxy S7" }, new { Id = new Guid("5c2996ab-54ad-4999-92d2-89245682d534"), ProductId = new Guid("de1287c0-4b15-4a7b-9d8a-dd21b3cafec3"), Name = "Rose Gold", Description = "Gold Apple iPhone 6S" }, new { Id = new Guid("9ae6f477-a010-4ec9-b6a8-92a85d6c5f03"), ProductId = new Guid("de1287c0-4b15-4a7b-9d8a-dd21b3cafec3"), Name = "White", Description = "White Apple iPhone 6S" }, new { Id = new Guid("4e2bc5f2-699a-4c42-802e-ce4b4d2ac0ef"), ProductId = new Guid("de1287c0-4b15-4a7b-9d8a-dd21b3cafec3"), Name = "Black", Description = "Black Apple iPhone 6S" } }); } }