title: How can I properly bind and fill Kendo UI grid with two table EF?
body: <p>My project has two main issues that prevent me from being able to do a normal, basic Kendo UI gridbind. 1. I do not have full access to the required SQL data (I cannot create a view) 2. One of the fields is incredibly large (the field overloads a ViewModel).</p>
  
  <p>I was able to get my grid to work, but I feel that there is a better way to accomplish the task. My problem, essentially, is that I can only seem to gridbind to a single table of DB. To get passed this, I bound to the foreign key field and used a clientTemplate to fill the data from the read, but I feel like there should be a more direct way to be able to bind the field to the data. My read data is an actionresult Linq join from EF, converted to JSON.
  Here is my code, if anyone can make a suggestion. D_Type from table 2 is what I am trying to bind directly to the column:</p>
  
  <pre><code>@(Html.Kendo().Grid&lt;ProjectName.Models.Table1&gt;()
      .Name("grid")
      .Scrollable()
      .ColumnMenu()
      .Reorderable(reorder =&gt; reorder.Columns(true))
      .Columns(columns =&gt;
      {
  
          columns.Bound(c =&gt; c.P_Name);
          columns.Bound(c =&gt; c.E_Name);
          //Cannot be directly bound to a column because it is part of Table2 table
          columns.Bound(c =&gt; c.TypeId).Title("Type").ClientTemplate("#= D_Type #").Filterable(false);            
          columns.Command(command =&gt; command.Custom("Details").Click("showDetails")).Title("Results").Width(80);
          columns.Bound(c =&gt; c.Destination);
          columns.Bound(c =&gt; c.Location);
          columns.Bound(c =&gt; c.Version);
          columns.Bound(c =&gt; c.StartDt);
          columns.Bound(c =&gt; c.EndDt);
          columns.Bound(c =&gt; c.StartDt).Title("Duration").ClientTemplate("#: calcDuration(StartDt, EndDt) #").Sortable(false).Filterable(false);
          columns.Bound(c =&gt; c.);
          columns.Bound(c =&gt; c.MiscNotes).ClientTemplate("#: errorDisplay(ResultObject) # ").Sortable(false).Filterable(false);
  
  
      })
      //Style dictates full grid height
      .HtmlAttributes(new { style = "height: 725px;" })
      .Filterable()
      .Resizable(resize =&gt; resize.Columns(true))
      .Sortable(sortable =&gt; sortable
          .AllowUnsort(true)
          .SortMode(GridSortMode.SingleColumn))
      .Pageable(pageable =&gt; pageable
          .Refresh(false)
          .PageSizes(true)
          .ButtonCount(5))
      .Events(e =&gt; e.DataBound("onDataBound"))
      .DataSource(dataSource =&gt; dataSource
          .Ajax()
          .Sort(sort =&gt; sort.Add("StartDt").Descending())
          .Read(read =&gt; read.Action("Project_Read", "Grid"))
          .PageSize(20)
          .ServerOperation(true)
      )
      )
  </code></pre>