Foreign Key Just showing a number which is associated with the primary key RSS

• • Reply
  

  TommyGun123

  0 Points

  1 Post

  Foreign Key Just showing a number which is associated with the primary key

  Apr 07, 2012 11:34 PM|LINK

  Hi people am new to this website am hoping you can help me

  I want a way in which I can display the value of the Foreign key which in my case is Game and instead of the Game Number i want to display the name then displaying a number. For example I have the following view to show all reviews:

  using System;
  using System.Collections.Generic;
  using System.Data;
  using System.Data.Entity;
  using System.Linq;
  using System.Web;
  using System.Web.Mvc;
  using Games.Models;
  
  
  namespace Games.Controllers
  {
      public class ShowAllReviewsController : Controller
      {
          //
          // GET: /ShowAllReviews/
  
          public ActionResult Index()
          {
              using (var db = new gamezoneDBEntities())
              {
  
                  return View(db.tblReviews.ToList());
             
  
              }
          }
  
          //
          // GET: /ShowAllReviews/Details/5
  
          public ActionResult Details(int id)
          {
              return View();
          }
  
          //
          // GET: /ShowAllReviews/Create
  
          public ActionResult Create()
          {
              return View();
          }
  
          //
          // POST: /ShowAllReviews/Create
  
          [HttpPost]
          public ActionResult Create(FormCollection collection)
          {
              try
              {
                  // TODO: Add insert logic here
  
                  return RedirectToAction("Index");
              }
              catch
              {
                  return View();
              }
          }
          
          //
          // GET: /ShowAllReviews/Edit/5
   
          public ActionResult Edit(int id)
          {
              return View();
          }
  
          //
          // POST: /ShowAllReviews/Edit/5
  
          [HttpPost]
          public ActionResult Edit(int id, FormCollection collection)
          {
              try
              {
                  // TODO: Add update logic here
   
                  return RedirectToAction("Index");
              }
              catch
              {
                  return View();
              }
          }
  
          //
          // GET: /ShowAllReviews/Delete/5
   
          public ActionResult Delete(int id)
          {
              return View();
          }
  
          //
          // POST: /ShowAllReviews/Delete/5
  
          [HttpPost]
          public ActionResult Delete(int id, FormCollection collection)
          {
              try
              {
                  // TODO: Add delete logic here
   
                  return RedirectToAction("Index");
              }
              catch
              {
                  return View();
              }
          }
      }
  }

  
  I have tried the following:

  @Html.DisplayFor(modelItem => item.tblGame.GameName)

  
  

  But i get this error:

  The ObjectContext instance has been disposed and can no longer be used for operations that require a connection.
  
  
  My view looks like this:
  
  

  @model IEnumerable<Games.Models.tblReview>
  
  @{
      ViewBag.Title = "Index";
  }
  
  <h2>Index</h2>
  
  <p>
      @Html.ActionLink("Create New", "Create")
  </p>
  <table>
      <tr>
          <th>
              ReviewID
          </th>
          <th>
              Recomendation
          </th>
          <th>
              AvoidOrBuy
          </th>
          <th>
              Score
          </th>
          <th>
              GameIDFK
          </th>
          <th>
              UserName
          </th>
          <th></th>
      </tr>
  
  @foreach (var item in Model) {
      <tr>
          <td>
              @Html.DisplayFor(modelItem => item.ReviewID)
          </td>
          <td>
              @Html.DisplayFor(modelItem => item.Recomendation)
          </td>
          <td>
              @Html.DisplayFor(modelItem => item.AvoidOrBuy)
          </td>
          <td>
              @Html.DisplayFor(modelItem => item.Score)
          </td>
          <td>
              @Html.DisplayFor(modelItem => item.GameIDFK)
          </td>
          <td>
              @Html.DisplayFor(modelItem => item.UserName)
          </td>
          <td>
              @Html.ActionLink("Edit", "Edit", new { /* id=item.PrimaryKey */ }) |
              @Html.ActionLink("Details", "Details", new {  id=item.ReviewID }) |
              @Html.ActionLink("Delete", "Delete", new { /* id=item.PrimaryKey */ })
          </td>
      </tr>
  }
  
  </table>
  

  
  

  C mvc3

  • Edited by TommyGun123 on Apr 07, 2012 11:34 PM
• • Reply
  

  BrockAllen

  All-Star

  27534 Points

  4907 Posts

  MVP

  Re: Foreign Key Just showing a number which is associated with the primary key

  Apr 07, 2012 11:48 PM|LINK

  @Html.DisplayFor(modelItem => item.tblGame.GameName)

  is the right idea, but you need to do this from your controller and populate a view model with it.The view model is what you then pass to the view, not your domain/entity model.

  Read up on the www.asp.net/mvc tutorials for the concept and examples of using view models.

  Brock Allen | http://brockallen.com
  DevelopMentor | http://www.develop.com
  thinktecture | http://www.thinktecture.com/
  • Marked as answer by Young Yang - MSFT on Apr 22, 2012 06:18 AM
• • Reply
  

  Slicksim

  Participant

  1925 Points

  350 Posts

  Re: Foreign Key Just showing a number which is associated with the primary key

  Apr 11, 2012 07:40 PM|LINK

  Hi,

  Sounds like you are using lazyloading in the db context, if you create it in a using block it will be disposed before all the data is pulled in.

  For web apps where there is a distinct disconnect, I like to turn lazyloading off and make sure that all my entities are populated ready for display in the views.

  Si

  Linkedin: http://uk.linkedin.com/in/simonlcooper