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();
}
