private static void ModifyCustomer()
{
using (var dbContext = new NorthwindEntities())
{
var luckyCustomer = dbContext.Customers.FirstOrDefault();
luckyCustomer.Country = "Bulgaria";
dbContext.SaveChanges();
}
Console.WriteLine("The customer was modified successfully");
}
private static void DeleteCustomer()
{
using (var dbContext = new NorthwindEntities())
{
var unluckyCustomer = dbContext.Customers.Where(c => c.CustomerID == "100").FirstOrDefault();
dbContext.Customers.Remove(unluckyCustomer);
dbContext.SaveChanges();
}
Console.WriteLine("The customer was deleted successfully");
}
private static void InsertCustomer()
{
using (var dbContext = new NorthwindEntities())
{
dbContext.Customers.Add(new Customer()
{
CompanyName = "Fake company",
CustomerID = "100"
});
dbContext.SaveChanges();
}
Console.WriteLine("The customer was added successfully");
}
public static void Main(string[] args)
{
var firstDbContext = new NorthwindEntities();
var secondDbContext = new NorthwindEntities();
var randomRegion = firstDbContext.Regions.FirstOrDefault();
var anotherRandomRegion = secondDbContext.Regions.FirstOrDefault();
randomRegion.RegionDescription = "Changed Description 1";
anotherRandomRegion.RegionDescription = "changed Description 2";
firstDbContext.SaveChanges();
secondDbContext.SaveChanges();
firstDbContext.Dispose();
secondDbContext.Dispose();
var thirdDbContext = new NorthwindEntities();
var actualRegion = thirdDbContext.Regions.FirstOrDefault();
Console.WriteLine(actualRegion.RegionDescription);
}