public static void Main() { NorthwindEntities db = new NorthwindEntities(); using (db) { db.Employees.Include("Territories"); var employeesData = db.Employees .Select(e => new { Employee = e, Territories = e.Territories.Select(t => t.TerritoryDescription) }) .ToList(); foreach (var data in employeesData) { Console.WriteLine(data.Employee.FirstName + " " + data.Employee.LastName); Console.WriteLine("Territories:"); foreach (var teritory in data.Territories) { Console.WriteLine(teritory); } Console.WriteLine(new string('-', 50)); } } }
public static void UpdateCustomer( string id, string commpanyName, string contactName, string contactTitle, string address, string city, string region, string postalCode, string country, string phone, string fax) { var db = new NorthwindEntities(); using (db) { Customer customer = db.Customers.Where(c => c.CustomerID == id).FirstOrDefault(); customer.CustomerID = id; customer.CompanyName = commpanyName; customer.ContactName = contactName; customer.ContactTitle = contactTitle; customer.Address = address; customer.City = city; customer.Region = region; customer.PostalCode = postalCode; customer.Country = country; customer.Phone = phone; customer.Fax = fax; db.SaveChanges(); } }
public static void DeleteCustomerById(string id) { var db = new NorthwindEntities(); using (db) { Customer customer = db.Customers.Where(c => c.CustomerID == id).FirstOrDefault(); db.Customers.Remove(customer); db.SaveChanges(); } }
public static void Main() { var db = new NorthwindEntities(); using (db) { var customers = db.Orders .Where(o => o.OrderDate.Value.Year == 1997 && o.ShipCountry == "Canada") .Select(o => o.Customer) .ToList(); foreach (var customer in customers) { Console.WriteLine(customer.ContactName); } } }
public static void SelectCustomers() { NorthwindEntities db = new NorthwindEntities(); string nativeSqlQuery = @"SELECT c.[CustomerID], c.[CompanyName], c.[ContactName], c.[ContactTitle], c.[Address], c.[City], c.[Region], c.[PostalCode], c.[Country], c.[Phone], c.[Fax] FROM Northwind.dbo.Orders o INNER JOIN Northwind.dbo.Customers c ON (o.CustomerID = c.CustomerID) WHERE YEAR(o.OrderDate) = 1997 AND o.ShipCountry = 'Canada'"; using (db) { var queryResult = db.Database.SqlQuery<CustomerFromDatabase>(nativeSqlQuery); var customers = queryResult.ToList(); foreach (var customer in customers) { Console.WriteLine(customer.ContactName); } } }
public static void Main() { NorthwindEntities db = new NorthwindEntities(); string regionName = "RJ"; DateTime startDate = new DateTime(1996, 7, 16); DateTime endDate = new DateTime(1997, 5, 6); using (db) { var sales = db.Orders .Where(o => startDate <= o.ShippedDate && endDate >= o.ShippedDate && o.ShipRegion == regionName) .ToList(); foreach (var sale in sales) { Console.WriteLine(string.Format("{0} -> {1}", sale.ShipRegion, sale.ShippedDate)); } } }
public static void Main() { NorthwindEntities db = new NorthwindEntities(); string differentConnectionString = ConfigurationManager.ConnectionStrings["NorthwindEntities"].ConnectionString; Console.WriteLine(differentConnectionString); using (db) { bool created = db.Database.CreateIfNotExists(); if (created) { Console.WriteLine("Database NorthwindTwin created!"); } else { Console.WriteLine("Database NorthwindTwin already exist!"); } } }
public static void Main() { NorthwindEntities dbOne = new NorthwindEntities(); NorthwindEntities dbTwo = new NorthwindEntities(); dbOne.Database.Connection.Open(); Employee employee = new Employee() { LastName = "Minkov", FirstName = "Doncho", Title = "Dev Manager", TitleOfCourtesy = "Mr", BirthDate = new DateTime(1990, 08, 08), HireDate = new DateTime(2009, 05, 05), Address = "str.Alexander Malinov 31", City = "Sofia", PostalCode = "1001", Country = "Bulgaria" }; dbOne.Employees.Add(employee); dbOne.SaveChanges(); dbTwo.Database.Connection.Open(); Employee employeeToUpdate = dbTwo.Employees .Where(e => e.City.Equals("Sofia")) .FirstOrDefault(); employeeToUpdate.City = "London"; employeeToUpdate.Address = "Downing Street 10"; dbTwo.SaveChanges(); dbOne.Database.Connection.Close(); dbTwo.Database.Connection.Close(); }
public static void InsertCustomer( string id, string commpanyName, string contactName, string contactTitle, string address, string city, string region, string postalCode, string country, string phone, string fax) { var db = new NorthwindEntities(); using (db) { Customer customer = new Customer() { CustomerID = id, CompanyName = commpanyName, ContactName = contactName, ContactTitle = contactTitle, Address = address, City = city, Region = region, PostalCode = postalCode, Country = country, Phone = phone, Fax = fax }; db.Customers.Add(customer); db.SaveChanges(); } }