title: Trying to concatenate columns in LINQ
body: <p>I'm trying to concatenate 2 columns into 1 column for my resultset.</p>
  
  <pre><code>var gridInfo = from leader in db.SchoolLdrAdminAccesses
                 join emp in db.Employees
                 on leader.ID equals emp.ID
                 select new List&lt;string&gt; { leader.ID, string.Format("{0}{1}", emp.FirstName, emp.LastName) };
  </code></pre>
  
  <p><strong>I'm getting this error:</strong></p>
  
  <blockquote>
    <p>LINQ to Entities does not recognize the method 'System.String
    Format(System.String, System.Object, System.Object)' method, and this
    method cannot be translated into a store expression.</p>
  </blockquote>
  
  <p>What am I doing incorrectly?</p>
  
  <p>I have to keep this:</p>
  
  <pre><code>select new List&lt;string&gt; {...}
  </code></pre>
  
  <p>As I am then doing this and I need it in the List structure.</p>
  
  <pre><code>        return Json(new
          {
              sEcho = param.sEcho,
              iTotalRecords = gridInfo.Count(),
              iTotalDisplayRecords = gridInfo.Count(),
              aaData = gridInfo.ToArray()
          },
          JsonRequestBehavior.AllowGet);
  </code></pre>