private static void SelectCustomers()
{
using (var context = new OnlineStoreContext())
{
var allCustomers = context.Customers.Skip(1).Take(1).OrderBy(c => c.Id).FirstOrDefault();
Console.WriteLine(allCustomers.Name);
/*foreach (var customer in allCustomers)
* {
* Console.WriteLine(customer.Name);
* }
*
* var allCustomersLinq = (
* from c
* in context.Customers
* select c.Name
* );
* foreach (var customer in allCustomersLinq)
* {
* Console.WriteLine(customer);
* }*/
}
}
private static void InsertCustomers()
{
using (var context = new OnlineStoreContext())
{
context.Customers.Add(new Customer()
{
Name = "Sheva"
});
context.Add(new Customer()
{
Name = "Albet"
});
context.AddRange(new[] { new Customer()
{
Name = "Masha"
}, new Customer()
{
Name = "Dasha"
} });
context.SaveChanges();
//Faster if you use bulkcopy(tempTable)
//Console.WriteLine($"{customer.Name }{customer.Id }");
}
}
private static void QueryAndUpdateProductDisconnected()
{
var product = _context.Products.First();
product.Price *= 1.1M;
//_context.Products.Update(product);
using (var newContext = new OnlineStoreContext())
{
newContext.Products.Update(product);
newContext.SaveChanges();
}
}
private static void InsertProducts()
{
using (var context = new OnlineStoreContext())
{
context.Add(new Product()
{
Name = "IPhone X", Price = 100
});
context.AddRange(new[] { new Product()
{
Name = "MacBook Pro", Price = 100
}, new Product()
{
Name = "IWatch", Price = 200
} });
context.SaveChanges();
}
}
private static void CreateOrder(string customerName, List <OrderItem> orederItems)
{
using (var context = new OnlineStoreContext())
{
context.Add(new Order()
{
Customer = context.Customers.Where(x => x.Name == customerName).FirstOrDefault(),
OrderDate = DateTimeOffset.Now,
Discount = 0,
OrderItems = new List <OrderItem>()
{
new OrderItem()
{
Product = new Product()
{
Name = "SamsungTV", Price = 20000
}
}
}
});
}
}