Querying Database MVC 4
===

I'm learning MVC from sample application MVC Music Store. It has two database tables, one called 'Order' and the other 'OrderDetails'. If an order is made and a customer selects more than one item, after checkout each item bought creates a new row in the OrderDetails database and the OrderDetailsID will increment. 

The OrderDetail database looks like:

    http://imagebin.org/221494


I want to write a controller that will just pass all rows which have the same particular OrderId. For example, in that database there are 3 rows each with the same OrderId '3'.

How can I do this and pass it to a razor view? I've tried:

    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Entity;
    using System.Linq;
    using System.Web;
    using System.Web.Mvc;
    using MvcMusicStore.Models;

    namespace Test.Controllers
    {
    public class OrderDetailsController : Controller
    {
        private MusicStoreEntities db = new MusicStoreEntities();

              //
        // GET: /OrderDetails/Details/5

        public ActionResult Details(int id = 0)
        {
            OrderDetail orderdetail = db.OrderDetails.Find(id);
            if (orderdetail == null)
            {
                return HttpNotFound();
            }
            return View(orderdetail);
        }

This will return a single result based on OrderDetailsId and not several results all with the same OrderId. I should be able to visit ....:11091/orderdetails/Details/3 and see not one result but a list of three different albums and their prices. 

Is there a simple way to do this? Thanks for advice. 


  [1]: http://imagebin.org/221494