// This method will create and seed the database.
public void Initialize(CustomerApiContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
// Look for any Products
if (context.Customers.Any())
{
return; // DB has been seeded
}
List <Customer> customers = new List <Customer>
{
new Customer {
CustomerId = 1, FullName = "Peder Hansen", Email = "*****@*****.**", Phone = "12345678", CreditStanding = 500, BillingAddress = "Gade 1B, Tyskland", ShippingAddress = "Gade 1B, Tyskland"
},
new Customer {
CustomerId = 2, FullName = "Fredrik Hansen", Email = "*****@*****.**", Phone = "12345678", CreditStanding = 200, BillingAddress = "Gade 1B, Tyskland", ShippingAddress = "Gade 1B, Tyskland"
},
new Customer {
CustomerId = 3, FullName = "Louise Pedersen", Email = "*****@*****.**", Phone = "12345678", CreditStanding = 0, BillingAddress = "Gade 1B, Tyskland", ShippingAddress = "Gade 1B, Tyskland"
},
new Customer {
CustomerId = 4, FullName = "Frederika Laudsen", Email = "*****@*****.**", Phone = "12345678", CreditStanding = 5500, BillingAddress = "Gade 1B, Tyskland", ShippingAddress = "Gade 1B, Tyskland"
},
new Customer {
CustomerId = 5, FullName = "Hans Peder", Email = "*****@*****.**", Phone = "12345678", CreditStanding = 2500, BillingAddress = "Gade 1B, Tyskland", ShippingAddress = "Gade 1B, Tyskland"
}
};
context.Customers.AddRange(customers);
context.SaveChanges();
}
// This method will create and seed the database.
public static void Initialize(CustomerApiContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
// Look for any Customers
if (context.Customers.Any())
{
return; // DB has been seeded
}
List <Customer> customers = new List <Customer>
{
new Customer {
CompanyName = "Company1", Email = "*****@*****.**", BillingAddress = "Home1"
},
new Customer {
CompanyName = "Company2", Email = "*****@*****.**", BillingAddress = "Home2"
},
new Customer {
CompanyName = "Company3", Email = "*****@*****.**", BillingAddress = "Home3"
}
};
context.Customers.AddRange(customers);
context.SaveChanges();
}
public static void Initialize(CustomerApiContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
// Look for any Products
if (context.Customers.Any())
{
return; // DB has been seeded
}
var Address1 = new Address()
{
Id = 1,
City = "Esbjerg",
Country = "Danmark",
StreetName = "Fynsgade 33",
ZipCode = 6700
};
var Address2 = new Address()
{
Id = 2,
City = "Esbjerg",
Country = "Danmark",
StreetName = "Tarp byvej 50",
ZipCode = 6715
};
List <Customer> customers = new List <Customer>
{
new Customer
{
RegNo = 1,
Email = "*****@*****.**",
Phone = "12345678",
CompanyName = "Some Company A/S",
BillingAddress = Address1,
ShippingAddress = Address1
},
new Customer
{
RegNo = 2,
Email = "*****@*****.**",
Phone = "87654321",
CompanyName = "Some Other Company A/S",
ShippingAddress = Address2,
BillingAddress = Address2
}
};
context.Customers.AddRange(customers);
context.SaveChanges();
}
// This method will create and seed the database.
public static void Initialize(CustomerApiContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
//// Look for any Products
//if (context.Orders.Any())
//{
// return; // DB has been seeded
//}
//List<Order> orders = new List<Order>
//{
// new Order { Date = DateTime.Today, ProductId = 1, Quantity = 2 }
//};
//context.Orders.AddRange(orders);
context.SaveChanges();
}
// This method will create and seed the database.
public static void Initialize(CustomerApiContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
// Look for any Products
if (context.Customers.Any())
{
return; // DB has been seeded
}
List <Customer> customers = new List <Customer>
{
new Customer {
BillingAddress = "Havnegade 63 B, 6700, Esbjerg", CompanyName = "EASV", Email = "*****@*****.**", Phone = "1345 5684", ShippingAddress = "Havnegade 63 B, 6700, Esbjerg"
}
};
context.Customers.AddRange(customers);
context.SaveChanges();
}
// This method will create and seed the database.
public static void Initialize(CustomerApiContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
//// Look for any Products
//if (context.Orders.Any())
//{
// return; // DB has been seeded
//}
List <Customer> orders = new List <Customer>
{
new Customer
{
CompanyName = "Cardboard Murders Inc.",
Email = "*****@*****.**",
ShippingAddress = new Address()
{
City = "Nowhere",
StreetAddress = "Cardboard box at the corner of 53rd and 22nd",
ZipCode = "????"
},
Phone = "Payphone at 53rd st",
BillingAddress = new Address()
{
City = "Washington, DC",
StreetAddress = "The White House, 1600 Pennsylvania Ave NW",
ZipCode = "20500"
}
}
};
context.Customers.AddRange(orders);
context.SaveChanges();
}
// This method will create and seed the database.
public void Initialize(CustomerApiContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
if (context.Customers.Any())
{
// Check if DB has been seeded.
return;
}
List <Customer> customers = new List <Customer>
{
new Customer {
Id = 1, Name = "customer1", Email = "*****@*****.**", PhoneNumber = "1234", BillingAddress = "billingAddress1", ShippingAddress = "shippingAddress1", CreditStanding = true
},
new Customer {
Id = 2, Name = "customer2", Email = "*****@*****.**", PhoneNumber = "5678", BillingAddress = "billingAddress2", ShippingAddress = "shippingAddress2", CreditStanding = false
}
};
context.Customers.AddRange(customers);
context.SaveChanges();
}
public void SeedWithData(CustomerApiContext CustomerApiContext)
{
/// Deleting & Creating DB - memory
CustomerApiContext.Database.EnsureDeleted();
CustomerApiContext.Database.EnsureCreated();
List <Customer> Customers = new List <Customer>()
{
new Customer()
{
Name = "Bent Jorgen",
VATNumber = "12345678"
},
new Customer()
{
Name = "Hussain Larsen",
VATNumber = "87654321"
}
};
CustomerApiContext.Customers.AddRange(Customers);
CustomerApiContext.SaveChanges();
}
// This method will create and seed the database.
public static void Initialize(CustomerApiContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
// Look for any Customers
if (context.Customers.Any())
{
return; // DB has been seeded
}
List <Customer> customers = new List <Customer>
{
new Customer {
Name = "Jhon Doe", RegistrationNumber = 1, Phone = 12313123, Email = "*****@*****.**", BillingAddress = "Youareaperfectionist street 43, Esbjerg", ShippingAddress = "Isthisbetter road 23, Esbjerg", HasOutstanding = false
},
new Customer {
Name = "Jhon Doe2", RegistrationNumber = 2, Phone = 12313123, Email = "*****@*****.**", BillingAddress = "Some street 11, Malmö", ShippingAddress = "Something road -1, King's Landing", HasOutstanding = true
},
};
context.Customers.AddRange(customers);
context.SaveChanges();
}
public CustomerRepository(CustomerApiContext context)
{
db = context;
}
public CustomerRepository(CustomerApiContext context, ILogger <Customer> logger)
{
_ctx = context;
_logger = logger;
}
