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