title: MVC LINQ Query question
body: <p>In my</p>
  
  <pre><code>public ActionResult Active()
  {
      var list = _entity.CALL_UP.Where(s =&gt; s.STATE == ICallUpsState.FULLY_SIGNED)
                                .Where(f =&gt; f.START_DATE &lt;= DateTime.Today 
                                         &amp;&amp; f.END_DATE &gt;= DateTime.Today)
                                .ToList();
      return View(list);
  }
  </code></pre>
  
  <p>This returns an <code>IEnumerable&lt;CallUP&gt;</code> with the correct result, but I want USER_ID to be displayed as User Name which is in another table. How do I do that?</p>
  
  <p>For Example:</p>
  
  <pre><code>&lt;%: String.Format("{0:F}", item.CREATED_BY_USER_ID) %&gt; this is an ID
  </code></pre>
  
  <p>the actual user name is stored in another table, I want to display that user name instead</p>