public static void EditCustumer(string id, string companyName, string contactName)
        {
            using (var baseConn = new NorthwindEntities())
            {
                bool successs = false;
                try
                {
                    Customer custumerToEdit = baseConn.Customers.Find(id);

                    custumerToEdit.CompanyName = companyName;
                    custumerToEdit.ContactName = contactName;

                    baseConn.SaveChanges();
                    successs = true;
                }
                finally
                {
                    if (successs)
                    {
                        Console.WriteLine("Custumer modified");
                    }
                    else
                    {
                        Console.WriteLine("Custumer could not be modified");
                    }
                }
            }
        }
        public static void AddCustomer(string id, string companyName, string contactName, string contactTitle, string address, string city,
            string region, string postalCode, string country, string phone, string fax)
        {
            using (var baseConn = new NorthwindEntities())
            {
                bool success = false;
                try
                {
                    Customer newCustomer = new Customer
                            {
                                CustomerID = id,
                                CompanyName = companyName,
                                ContactName = contactName,
                                ContactTitle = contactTitle,
                                Address = address,
                                City = city,
                                Region = region,
                                PostalCode = postalCode,
                                Country = country,
                                Phone = phone,
                                Fax = fax
                            };

                    if (baseConn.Customers.Find(newCustomer.CustomerID) == null && newCustomer.CustomerID != null)
                    {
                        baseConn.Customers.Add(newCustomer);
                        baseConn.SaveChanges();
                        success = true;
                    }
                }
                finally
                {
                    if (success)
                    {
                        Console.WriteLine("Custumer added");
                    }
                    else
                    {
                        Console.WriteLine("Custumer not added");
                    }
                }
            }
        }
        public static Customer GetCustomerByCriterion(string criterion, string searchValue)
        {
            Customer result = null;

            using (var baseConn = new NorthwindEntities())
            {
                foreach (var item in baseConn.Customers)
                {
                    var itemProp = item.GetType().GetProperty(criterion);
                    if (itemProp.GetValue(item, null).ToString() == searchValue)
                    {
                        result = item;
                        break;
                    }

                }
            }

            return result;
        }
        public static void RemoveCustomer(string id)
        {
            using (var baseConn = new NorthwindEntities())
            {
                bool success = false;

                try
                {
                    var element = baseConn.Customers.Find(id);
                    baseConn.Customers.Remove(element);
                    baseConn.SaveChanges();
                    success = true;
                }
                finally
                {
                    if (success)
                    {
                        Console.WriteLine("Custumer deleted");
                    }
                    else
                    {
                        Console.WriteLine("Custumer could not be deleted");
                    }
                }
            }
        }