/// <summary>
/// In order for this to create a twin base of NORTHWIND you have to change
/// the 'initial catalog' to the name of the twin db (NORTHWINDtwin in this case)
/// This will create a twin base ONLY if no such base with the same name exists in MSSQL database catalog
/// </summary>
public static void Main()
{
var dbContext = new NORTHWNDEntities();
CreateTwinDatabase(dbContext);
// DeleteDatabase(dbContext);
}
public static void Main(string[] args)
{
using (var db = new NORTHWNDEntities())
{
foreach (var employee in db.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);
}
}
}
private static void SelectEmployeeNamesByCountryAndCity( string country, int year)
{
NORTHWNDEntities northwindEntities = new NORTHWNDEntities();
string nativeSqlQuery =
"SELECT CONCAT(c.ContactName , ' | ' , o.OrderDate , ' | ' , o.ShipCountry) AS [Customer]" +
"FROM Customers c " +
"JOIN Orders o " +
"ON c.CustomerID = o.CustomerID " +
"WHERE YEAR(o.OrderDate) = {1} AND o.ShipCountry = {0} " +
"ORDER BY c.ContactName DESC";
object[] parameters = { country, year };
var customers = northwindEntities.Database.SqlQuery<string>(
nativeSqlQuery, parameters);
foreach (var emp in customers)
{
Console.WriteLine(emp);
}
}
public static void Main(string[] args)
{
var startDate = new DateTime(1995, 01, 01);
var endDate = new DateTime(1997, 01, 01);
using (var db = new NORTHWNDEntities())
{
var sales = db.Orders
.Where(o => o.ShipRegion == region &&
o.OrderDate > startDate &&
o.OrderDate < endDate)
.ToList();
foreach (var sale in sales)
{
Console.WriteLine("Order ID: " + sale.OrderID);
Console.WriteLine(sale.OrderDate);
}
}
}
private static void Main()
{
Console.WriteLine("-- Establishing first connection to database Northwind...");
using (var firstDb = new NORTHWNDEntities())
{
var firstCategory = firstDb.Categories.Find(4);
Console.WriteLine("Initial category description: {0}", firstCategory.Description);
firstCategory.Description = "Cheese and many more";
Console.WriteLine("Category description after changing: {0}", firstCategory.Description);
Console.WriteLine("-- Establishing second connection to database Northwind...");
using (var secondDb = new NORTHWNDEntities())
{
var secondCategory = secondDb.Categories.Find(4);
Console.WriteLine("Initial category description: {0}", secondCategory.Description);
secondCategory.Description = "Cheese and many, many more";
Console.WriteLine("Category description after changing: {0}", secondCategory.Description);
firstDb.SaveChanges();
secondDb.SaveChanges();
Console.WriteLine("Category description after saving: {0}", secondCategory.Description);
}
Console.WriteLine("-- Closing second connection to the database...");
Console.WriteLine("Category description after saving: {0}", firstCategory.Description);
}
Console.WriteLine("-- Closing first connection to the database...");
using (var db = new NORTHWNDEntities())
{
Console.WriteLine("Actual result: {0}", db.Categories.Find(4).Description);
}
}
