public Employee GetEmployee(int id)
        {
            // TODO: retrieve the real product info from DB using EF

            NorthwindEntities context = new NorthwindEntities();
            var employeeEntity = (from p
                                in context.EmployeeEntities
                                 where p.EmployeeID == id
                                 select p).FirstOrDefault();

            if (employeeEntity != null)
                return TranslateEmployeeEntityToProduct(employeeEntity);
            else
                throw new Exception("Invalid Employee id");
        }
        public Product GetProduct(int id)
        {
            // TODO: retrieve the real product info from DB using EF
            /*
            Product product = new Product();
            product.ProductID = id;
            product.ProductName = "fake product name";
            product.UnitPrice = (decimal)10.0;
                */

            NorthwindEntities context = new NorthwindEntities();
            var productEntity = (from p
                                in context.ProductEntities
                                where p.ProductID == id
                                select p).FirstOrDefault();

            if (productEntity != null)
                return TranslateProductEntityToProduct(productEntity);
            else
                throw new Exception("Invalid product id");
        }