title: Linq Include statement returns an iCollection, which I cannot bind to Gridview Column
body: <p>At first I used the join statement to get unique items that I could bind to my Telerik Gridview:-</p>
  
  <pre><code>var result = ctx.Offenders
                  .Join(ctx.Fees, o =&gt; o.OffenderId, f =&gt; f.OffenderId,
                  (o, f) =&gt; new { Offenders = o, Fees = f })
                  .Join(ctx.ViolationOffenders, o =&gt; o.Offenders.OffenderId, vo =&gt; vo.OffenderId,
                  (o, vo) =&gt; new { Offenders = o, ViolationOffenders = vo })
                  .Join(ctx.Violations, v =&gt; v.ViolationOffenders.ViolationId, vo =&gt; vo.ViolationId,
                  (v, vo) =&gt; new { Violations = v, ViolationOffenders = vo }).ToList();
  </code></pre>
  
  <p>This worked like a charm. However I wanted to learn a bit more about linq and the include statement. So I developed a new query:-</p>
  
  <pre><code>var result = ctx.Offenders
                      .Include(o =&gt; o.Fees)
                      .Include(o =&gt; o.ViolationOffenders)
                      .Include(o =&gt; o.ViolationOffenders.Select(of =&gt; of.Violation))
                      .Where(o =&gt; o.YouthNumber != "" &amp;&amp; o.FirstName != "" &amp;&amp; o.Fees.Any(f =&gt; f.Amount != null))
                      .ToList();
  
  gvwData.DataSource = result;
  </code></pre>
  
  <p>I am happy with how much more compact my linq statement has turned out to be. But I am having issues binding the results to my Telerik Gridview.</p>
  
  <p>The telerik Grid has columns:-</p>
  
  <pre><code>&lt;Columns&gt;
      &lt;telerik:GridNumericColumn DataField = "YouthNumber" HeaderText="Offender ID" HeaderStyle-Width="100px" FilterControlWidth="50px" ColumnGroupName="GeneralInfo"/&gt;
      &lt;telerik:GridBoundColumn SortExpression ="LastName" DataField="LastName" HeaderText="LastName" ColumnGroupName="GeneralInfo"&gt;
      &lt;/telerik:GridBoundColumn&gt;
      &lt;telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" ColumnGroupName="GeneralInfo"/&gt;
      &lt;telerik:GridBoundColumn DataField="DateOfBirth" HeaderText="DOB" ColumnGroupName="GeneralInfo"/&gt;
      &lt;telerik:GridBoundColumn DataField="PoliceReportDate" HeaderText="Report Date" ColumnGroupName="GeneralInfo"/&gt;
      &lt;telerik:GridBoundColumn DataField="Amount" HeaderText="Payment Owed" ColumnGroupName="BillingInfo"/&gt;
  &lt;/Columns&gt;
  </code></pre>
  
  <p>The first 4 columns are first level data items in my variable result and they get bound to my Grid without any issues. However PoliceReportDate and Amount are returned as an iCollection....aka they are basically an array [] and not unique values for each individual gridRow as returned by my previous Linq statement.</p>
  
  <p>I am trying to figure out how I can still use my 2nd linq statement and be able to bind to my Grid. I am trying to learn all possibilities with linq and entity framework.</p>