public void DeleteCustomer_ShouldDeleteACustomer() { using (var db = new NorthwindEntities()) { string city = "City of angels"; Customer newCustomer = new Customer() { CustomerID = "LBCDM", CompanyName = "Telerik", ContactName = "Alex Frost", ContactTitle = "Very special guy", Address = "31 Al.Malinov", City = city, Region = null, PostalCode = "2000", Country = "Bulgaria", Phone = "55555555", Fax = null }; var customersCountBeforeDeleting = db.Customers .Select(c => c.City == city) .ToList() .Count; DAO.DeleteCustomer(newCustomer); var customersCountAfterDeleting = db.Customers .Select(c => c.City == city) .ToList() .Count; Assert.AreEqual(customersCountBeforeDeleting - 1, customersCountAfterDeleting); } }
public static void Main() { using (var db = new NorthwindEntities()) { var regions = db.Regions.Select(r => r.RegionDescription).ToList(); regions.ForEach(Console.WriteLine); } }
private static ICollection<Order> FindAllSalesByRegionAndPeriod(string region, DateTime start, DateTime end) { using (var db = new NorthwindEntities()) { var sales = db.Orders .Where(o => o.ShipRegion == region) .Where(o => o.OrderDate > start && o.ShippedDate < end) .ToList(); return sales; } }
private static ICollection<Customer> FindCustomersByOrdersMadeIn1997AndShippedToCanada() { using (var db = new NorthwindEntities()) { var customers = db.Orders .Where(o => o.OrderDate.Value.Year == 1997 && o.ShipCountry == "Canada") .Select(c => c.Customer) .ToList(); return customers; } }
public static void Main() { IObjectContextAdapter db = new NorthwindEntities(); string twin = db.ObjectContext.CreateDatabaseScript(); // Change the filename string createTwinCommandSql = "CREATE DATABASE NorthwindTwin ON PRIMARY " + "(NAME = NorthwindTwin, " + @"FILENAME = 'D:\\NorthwindTwin.mdf', " + "SIZE = 5MB, MAXSIZE = 10MB, FILEGROWTH = 10%) " + "LOG ON (NAME = NorthwindTwinLog, " + @"FILENAME = 'D:\\NorthwindTwin.ldf', " + "SIZE = 1MB, " + "MAXSIZE = 5MB, " + "FILEGROWTH = 10%)"; SqlConnection dbConnectionToCreateDB = new SqlConnection( "Server=.; " + "Database=master; " + "Integrated Security=true"); dbConnectionToCreateDB.Open(); using (dbConnectionToCreateDB) { SqlCommand createDB = new SqlCommand(createTwinCommandSql, dbConnectionToCreateDB); createDB.ExecuteNonQuery(); } SqlConnection dbConnectionToClone = new SqlConnection( "Server=.; " + "Database=NorthwindTwin; " + "Integrated Security=true"); dbConnectionToClone.Open(); using (dbConnectionToClone) { SqlCommand cloneDB = new SqlCommand(twin, dbConnectionToClone); cloneDB.ExecuteNonQuery(); } Console.WriteLine("Northwind twin created successfully."); }
public static void Main() { var query = "SELECT * FROM Customers c, Orders o " + "WHERE c.CustomerID = o.CustomerID " + "AND YEAR(o.OrderDate) = 1997 " + "AND o.ShipCountry = 'Canada'"; using (var db = new NorthwindEntities()) { var customers = db.Database.SqlQuery<Customer>(query); Console.WriteLine("Customers' contact names: "); foreach (var customer in customers) { Console.WriteLine(customer.ContactName); } } }
public void AddCustomer_ShouldThrowAnExceptionWhenTryingToAddCustomersWithTheSameId() { using (var db = new NorthwindEntities()) { Customer newCustomer = new Customer() { CustomerID = "LBCDM", CompanyName = "Telerik", ContactName = "Alex Frost", ContactTitle = "Very special guy", Address = "31 Al.Malinov", City = "City of angels", Region = null, PostalCode = "2000", Country = "Bulgaria", Phone = "55555555", Fax = null }; DAO.InsertCustomer(newCustomer); DAO.InsertCustomer(newCustomer); } }
public static void Main() { using (var firstDb = new NorthwindEntities()) { Console.WriteLine("First connection established."); var firstCategory = firstDb.Categories.FirstOrDefault(); Console.WriteLine("Initial first category name: {0}", firstCategory.CategoryName); firstCategory.CategoryName = "alcohol only"; Console.WriteLine("Category name set to: {0}", firstCategory.CategoryName); using (var secondDb = new NorthwindEntities()) { Console.WriteLine("Second connection established."); var secondCategory = secondDb.Categories.FirstOrDefault(); Console.WriteLine("Initial first category name: {0}", secondCategory.CategoryName); secondCategory.CategoryName = "nonalcohol only"; Console.WriteLine("Category name set to: {0}", secondCategory.CategoryName); firstDb.SaveChanges(); secondDb.SaveChanges(); Console.WriteLine("Changes have been saved."); } } using (var db = new NorthwindEntities()) { var category = db.Categories.FirstOrDefault(); Console.WriteLine("What is actually saved in the database:"); Console.WriteLine("First category name: {0}", category.CategoryName); } }
public void ModifyCustomer_ShouldModifyCustomersComapnyNameAndCompanyTitle() { using (var db = new NorthwindEntities()) { string id = "LBCDM"; string city = "City of angels"; Customer newCustomer = new Customer() { CustomerID = id, CompanyName = "Telerik", ContactName = "Alex Frost", ContactTitle = "Very special guy", Address = "31 Al.Malinov", City = city, Region = null, PostalCode = "2000", Country = "Bulgaria", Phone = "55555555", Fax = null }; DAO.InsertCustomer(newCustomer); DAO.ModifyCustomer(newCustomer); var customer = db.Customers .FirstOrDefault(c => c.CustomerID == id); Assert.AreNotEqual(newCustomer.ContactTitle, customer.ContactTitle); Assert.AreNotEqual(newCustomer.CompanyName, customer.CompanyName); DAO.DeleteCustomer(newCustomer); } }