Esempio n. 1
0
        static void Main(string[] args)
        {
            using (var db = new NorthwindEntities())
            {
                Customer newCustomer = new Customer()
                {
                    CustomerID = "TELEK",
                    CompanyName = "Telerik",
                    ContactName = "Peter Petrov",
                    ContactTitle = "Dr."
                };

                string newCustomerId = dbDaoTask2.InsertCustomer(newCustomer);
                Console.WriteLine("New customer inserted");
                var lastCustomer = db.Customers
                    .Where(cust => cust.CustomerID == newCustomerId)
                    .Select(c => new
                    {
                        ContactName = c.ContactName,
                        CompanyName = c.CompanyName
                    })
                    .FirstOrDefault();
                Console.WriteLine("Name {0}, Company {1}", lastCustomer.ContactName, lastCustomer.CompanyName);

                dbDaoTask2.RemoveCustomer(newCustomerId);
                Console.WriteLine("Customer removed");
            }
        }
Esempio n. 2
0
 public static void UpdateCustomer(Customer updatedCustomer)
 {
     using(var db=new NorthwindEntities())
     {
         db.Customers.Attach(updatedCustomer);
         db.SaveChanges();
     }
 }
Esempio n. 3
0
 public static void RemoveCustomer(string removeCustomerId)
 {
     using(var db=new NorthwindEntities())
     {
         Customer customer = db.Customers.FirstOrDefault(cust => cust.CustomerID == removeCustomerId);
         db.Customers.Remove(customer);
         db.SaveChanges();
     }
 }
Esempio n. 4
0
 public static string InsertCustomer(Customer customer)
 {
     using(var db=new NorthwindEntities())
     {
         try
         {
             db.Customers.Add(customer);
             db.SaveChanges();
         }
         catch (Exception e) { };
         return customer.CustomerID;
     }
 }