public ActionResult Orders()
        {
            var viewModel = 
                (from pd in db.Orders
                join p in db.Clients on pd.ClientId equals p.Id
                where pd.ClientId == p.Id select pd).ToList();
            return View(viewModel);
        }

public ActionResult CreateOrder()
        {
            Order order = new Order();
            return View(order);
        }

        [HttpPost]
        public ActionResult CreateOrder(Order order)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    db.Orders.Add(order);
                    db.SaveChanges();
                    return RedirectToAction("Orders");
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError(String.Empty, ex);
            }
            return View(order);
        }

@{
    var grid = new WebGrid(
        Model,rowsPerPage:5,
        defaultSort:"Name",
        columnNames:new [] {"Name", "ShipDate", "Article"}
        );
}

@grid.GetHtml(

fillEmptyRows:false,
mode:WebGridPagerModes.All,

columns:grid.Columns
(
grid.Column("Name", header:"Клиент"),
grid.Column("ShipDate", header:"Дата"),
grid.Column("Article", header:"Артикул")
)
)

        public ActionResult CreateOrder()
        {
            ViewBag.Client = new SelectList(db.Clients, "Id", "Name");
            return View();
        }

        [HttpPost]
        public ActionResult CreateOrder(Order order)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    db.Orders.Add(order);
                    db.SaveChanges();
                    return RedirectToAction("Orders");
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError(String.Empty, ex);
            }
            return View(order);
        }

            @Html.DropDownList("Client", (IEnumerable<SelectListItem>) ViewBag.Client, "--Выберите клиента--")
            @Html.ValidationMessageFor(model => model.ClientId)

            @Html.DropDownList("ClientId", (IEnumerable<SelectListItem>) ViewBag.Client, "--Выберите клиента--")
            @Html.ValidationMessageFor(model => model.ClientId)

        public ActionResult IngList()
        {
            var viewModel =
                (from il in db.IngLists
                 join p in db.Products on il.ProdId equals p.Id
                 join ing in db.Ingredients on il.IngId equals ing.Id
                 where (il.ProdId == p.Id) && (il.IngId == ing.Id)
                 select new IngListModel { p.Name, ing.Name, il.Amount }).ToList();
            return View(viewModel);
        }

namespace EnzoApp.Controllers
{
    class IngListModel
    {
        public string ProdName { get; set; }
        public string IngName { get; set; }
        public int Amount { get; set; }
    }
}

        public ActionResult IngList()
        {
            var viewModel =
                (from il in db.IngLists
                 join p in db.Products on il.ProdId equals p.Id
                 join ing in db.Ingredients on il.IngId equals ing.Id
                 where (il.ProdId == p.Id) && (il.IngId == ing.Id)
                 select new IngListModel { ProdName = p.Name, IngName = ing.Name, Amount = il.Amount }).ToList();
            return View(viewModel);
        }