CODEWITHSUNDEEP
asp.netasp.net-mvcmodel-view-controllerview
Gulzhanat Zhumazhanova
Gulzhanat Zhumazhanova

Reputation: 59

How can I initialize one model in another model's controller action?

I created a web-app in Asp.net MVC and it has an order action. I have these two models for Order

 public class Order
    {
        public int Id { get; set; }
        public DateTimeOffset OrderTime { get; set; }
        [InverseProperty("Order")]
        public ICollection<OrderDetail> OrderDetails { get; set; }
    }

and for OrderDetail

public class OrderDetail
    {
        public int Id { get; set; }
        public int OrderId { get; set; }
        public ICollection<Order> Order { get; set; }
        public int MenuId { get; set; }
        public int RestaurantId { get; set; }
        public Menu Menu { get; set; }
        public decimal Price { get; set; }
        public int Quantity { get; set; }
    }

And I created tables for them. Also I created a controller for Order. It contains Index and Details actions. Index acction shows the list of order and every order has its own Detail link which should contain information of Order and related OrderDetail

public ActionResult Details(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Order order = db.Orders.Find(id);
            if (order == null)
            {
                return HttpNotFound();
            }
            return View(order);
        }

And the problem is that OrderDetails is null. Can you suggest me how I can initialize OrderDetail in Details action?

Upvotes: 2

Views: 383

Answers (1)

Sir Rufo
Sir Rufo

Reputation: 19106

You have to tell EntityFramework which navigation properties you want to include.

Order order = db.Orders
    .Where( o => o.Id == id )
    .Include( o => o.OrderDetails )
    .SingleOrDefault();

But you cannot use Find method any more

Upvotes: 1

Related Questions