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