static void Main(string[] args)
{
//using (var db = new OneToManyDbContext())
//{
// var student = new Student()
// {
// Name = "Student A"
// };
// student.CurrentGrade = new Grade()
// {
// Section = "Grade A"
// };
// db.Students.Add(student);
// db.SaveChanges();
//}
using (var db = new OneToManyDbContext())
{
{
//db.Configuration.LazyLoadingEnabled = true;
//db.Configuration.LazyLoadingEnabled = false;
var firstGrade = db.Grades.First();
//db.Entry(firstGrade).Collection(p => p.Students).Load();
var amount = firstGrade.Students.Count;
}
}
}
static void Main(string[] args)
{
Customer customer = new Customer();
customer.Id = 567;
customer.Name = "Akash";
Order order = new Order();
order.OrderId = 56;
order.OrderCost = 50000;
order.OrderItem = "Electronics";
order.CustomerId = customer.Id;
LineItem item = new LineItem();
item.ID = 1111;
item.ItemName = "Plasma TV";
item.ItemPrice = 20000;
item.product = new Product {
ProductId = 1, ProductName = "Plasma TV"
};
item.OrderId = order.OrderId;
LineItem item2 = new LineItem();
item2.ID = 1112;
item2.ItemName = "LED TV";
item2.ItemPrice = 30000;
item2.product = new Product {
ProductId = 2, ProductName = "Led TV"
};
item2.OrderId = order.OrderId;
order.items.Add(item);
order.items.Add(item2);
Order order2 = new Order();
order2.OrderId = 78;
order2.OrderCost = 60000;
order2.OrderItem = "Auto Parts";
order2.CustomerId = customer.Id;
LineItem item3 = new LineItem();
item3.ID = 1123;
item3.ItemName = "Car Fender";
item3.ItemPrice = 60000;
item3.product = new Product {
ProductId = 3, ProductName = "Car Fender"
};
item3.OrderId = order2.OrderId;
order2.items.Add(item3);
Order order3 = new Order();
order3.OrderId = 91;
order3.OrderCost = 100000;
order3.OrderItem = "Computer";
order3.CustomerId = customer.Id;
LineItem item4 = new LineItem();
item4.ID = 1134;
item4.ItemName = "LapTop";
item4.ItemPrice = 40000;
item4.product = new Product {
ProductId = 4, ProductName = "LapTop"
};
item4.OrderId = order3.OrderId;
LineItem item5 = new LineItem();
item5.ID = 1135;
item5.ItemName = "Mac Book";
item5.ItemPrice = 60000;
item5.product = new Product {
ProductId = 5, ProductName = "Mac Book"
};
item5.OrderId = order3.OrderId;
order3.items.Add(item4);
order3.items.Add(item5);
customer.orders.Add(order);
customer.orders.Add(order2);
customer.orders.Add(order3);
Customer customer2 = new Customer();
customer2.Id = 789;
customer2.Name = "Parth";
Order order4 = new Order();
order4.OrderId = 34;
order4.OrderCost = 45000;
order4.OrderItem = "Fitness";
order4.CustomerId = customer2.Id;
LineItem item6 = new LineItem();
item6.ID = 1146;
item6.ItemName = "TreadMill";
item6.ItemPrice = 30000;
item6.product = new Product {
ProductId = 6, ProductName = "TreadMill"
};
item6.OrderId = order4.OrderId;
LineItem item7 = new LineItem();
item7.ID = 1147;
item7.ItemName = "Weights";
item7.ItemPrice = 10000;
item7.product = new Product {
ProductId = 7, ProductName = "Weights"
};
item7.OrderId = order4.OrderId;
LineItem item8 = new LineItem();
item8.ID = 1148;
item8.ItemName = "Track";
item8.ItemPrice = 5000;
item8.product = new Product {
ProductId = 8, ProductName = "Track"
};
item8.OrderId = order4.OrderId;
order4.items.Add(item6);
order4.items.Add(item7);
order4.items.Add(item8);
Order order5 = new Order();
order5.OrderId = 67;
order5.OrderCost = 50000;
order5.OrderItem = "Sports";
order5.CustomerId = customer2.Id;
LineItem item9 = new LineItem();
item9.ID = 1159;
item9.ItemName = "Dirt Bike";
item9.ItemPrice = 50000;
item9.product = new Product {
ProductId = 9, ProductName = "Dirt Bike"
};
item9.OrderId = order5.OrderId;
order5.items.Add(item9);
customer2.orders.Add(order4);
customer2.orders.Add(order5);
OneToManyDbContext context = new OneToManyDbContext();
context.Customers.Add(customer);
context.Customers.Add(customer2);
context.Order.Add(order);
context.Order.Add(order2);
context.Order.Add(order3);
context.Order.Add(order4);
context.Order.Add(order5);
context.LineItems.Add(item);
context.LineItems.Add(item2);
context.LineItems.Add(item3);
context.LineItems.Add(item4);
context.LineItems.Add(item5);
context.LineItems.Add(item6);
context.LineItems.Add(item7);
context.LineItems.Add(item8);
context.LineItems.Add(item9);
context.SaveChanges();
}