private static void ModifyNewInsertedCustomer(NorthwindEntities context) { var customer = context.Customers.First(); customer.City = "Sofia"; customer.Region = "Sofia"; context.SaveChanges(); }
public static void WorkTask() { using (NorthwindEntities context = new NorthwindEntities()) { context.Customers.First().City = "Plovdiv"; Thread.Sleep(1000); context.SaveChanges(); } }
public static void ManipulateDatabase() { using (NorthwindEntities context = new NorthwindEntities()) { InsertNewCustomersToDb(context); ModifyNewInsertedCustomer(context); DeleteNewInsertedCustomer(context); } }
public static void FindOrder(string region,DateTime startDate, DateTime endDateTime) { using (NorthwindEntities context = new NorthwindEntities()) { foreach (var order in context.Orders.Where(x=> x.ShipRegion.ToLower().Contains(region.ToLower()) && x.OrderDate >= startDate && x.OrderDate <= endDateTime)) { Console.WriteLine(order.OrderID); } } }
public static void FindCustormers() { using (NorthwindEntities context = new NorthwindEntities()) { foreach (var customer in context.Customers.Where(x=> x.Orders.Any(y=> y.OrderDate.HasValue && y.OrderDate.Value.Year == 1997 && y.ShipCountry == "Canada"))) { Console.WriteLine(customer.ContactName); } } }
private static void FindCustormersSQL() { const string nativeSqlQuery = "SELECT *" + "FROM Customers c " + "JOIN Orders o " + "ON c.CustomerID = o.CustomerID " + "WHERE YEAR(o.OrderDate) = 1997 AND o.ShipCountry = 'Canada'"; using (var db = new NorthwindEntities()) { var customers = db.Database.SqlQuery<Customer>(nativeSqlQuery); foreach (var customer in customers) { Console.WriteLine(customer.ContactName); } } }
private static void InsertNewCustomersToDb(NorthwindEntities context) { var newCustomer = new Customer { CustomerID = "1", CompanyName = "Lethdasdsaal Corporation", ContactName = "das Salvarez", ContactTitle = "dsa", Address = "33 Pedro Almodovar Sq.", City = "Ciudad dsa", PostalCode = "11223", Country = "Spain", Phone = "030-0023002", Fax = "030-0023003" }; context.Customers.Add(newCustomer); context.SaveChanges(); }
private static void DeleteNewInsertedCustomer(NorthwindEntities context) { var customer = context.Customers.First(); context.Customers.Remove(customer); context.SaveChanges(); }