static void ModifyNewInsertedCustomer() { var dataBase = new NorthwindEntities(); var customer = dataBase.Customers.First(); customer.ContactTitle = "CEO"; affectedRows = dataBase.SaveChanges(); Console.WriteLine("({0} row(s) affected)", affectedRows); }
static void DeleteNewInsertedCustomer() { var dataBase = new NorthwindEntities(); var customer = dataBase.Customers.First(); dataBase.Customers.Remove(customer); affectedRows = dataBase.SaveChanges(); Console.WriteLine("({0} row(s) affected)", affectedRows); }
static void Main(string[] args) { using (var dataBase = new NorthwindEntities()) { var customers = dataBase.Customers.Where(c => c.Orders.Any(x => x.OrderDate != null && (x.OrderDate.Value.Year == 1997 && x.ShipCountry == "Canada"))).ToList(); foreach (var item in customers) { Console.WriteLine(customers); } } }
static void Main(string[] args) { using (var dataBase = new NorthwindEntities()) { foreach (var employee in dataBase.Employees.Include("Territories")) { var correspondingTerritories = employee.Territories.Select(c => c.TerritoryID); var correspondingTerritoriesAsString = string.Join(", ", correspondingTerritories); Console.WriteLine("{0} -> Territory IDs: {1}", employee.FirstName, correspondingTerritoriesAsString); } } }
static void Main(string[] args) { using (var dataBase = new NorthwindEntities()) { Console.WriteLine("Executing queries..."); Thread.Sleep(1000); InsertNewCustomersToDb(); Thread.Sleep(1000); ModifyNewInsertedCustomer(); Thread.Sleep(1000); } Console.WriteLine("-- Closing connection to the database..."); }
static void Main(string[] args) { const string region = "SP"; var startDate = new DateTime(1995, 4, 9); var endDate = new DateTime(2001, 2, 1); using (var dataBase = new NorthwindEntities()) { var sales = dataBase.Orders.Where(o => o.ShipRegion == region && o.OrderDate >= startDate && o.OrderDate <= endDate).ToList(); foreach (var sale in sales) { Console.WriteLine("{0} | {1}", sale.ShipRegion, sale.OrderDate); } } }
static void Main(string[] args) { NorthwindEntities northwindEntities = new NorthwindEntities(); string nativeSqlQuery = "SELECT c.ContactName AS [Customer], o.OrderDate [Order Year],o.ShipCountry " + "FROM dbo.Orders o,dbo.Customers c " + "WHERE c.CustomerID = o.CustomerID AND YEAR(o.OrderDate) = 1997 AND o.ShipCountry = 'Canada'"; using (var dataBase = new NorthwindEntities()) { var customers = dataBase.Database.SqlQuery<View>(nativeSqlQuery); foreach (var customer in customers) { Console.WriteLine(customer); } } }
static void Main(string[] args) { using (var db = new NorthwindEntities()) { // You must change your App.config file in order to generate a clone of Northwind // Summary: // Creates a new database on the database server for the model defined in the backing // context, but only if a database with the same name does not already exist on // the server. // // Returns: // True if the database did not exist and was created; false otherwise. var flag = db.Database.CreateIfNotExists(); Console.WriteLine(flag); } }
static void InsertNewCustomersToDb() { var dataBase = new NorthwindEntities(); var newCustomer = new Customer { CustomerID = "AAAAA", CompanyName = "Lethal Corporation", ContactName = "Alfonso Salvarez", ContactTitle = "CEO", Address = "33 Pedro Almodovar Sq.", City = "Ciudad Real", Region = "BC", PostalCode = "11223", Country = "Spain", Phone = "030-0023002", Fax = "030-0023003" }; dataBase.Customers.Add(newCustomer); affectedRows = dataBase.SaveChanges(); Console.WriteLine("({0} row(s) affected)", affectedRows); }