I have a GridView that is bound to a LINQDataSource control that is returning a collection of customers.

Within my DataGrid I need to display the home phone number of a customer, if they have one. The phone numbers of a customer are stored in a separate table with a foreign key pointing to the customer table.

The following binding expression gets me the first phone number for a customer:

<asp:TemplateField HeaderText="LastName" SortExpression="LastName">
   <ItemTemplate>
      <asp:Label ID="PhoneLabel" runat="server" Text='<%# Eval("Phones[0].PhoneNumber") %>'></asp:Label>
   </ItemTemplate>
</asp:TemplateField>

I need to figure out how to get the home phone number specifically (filter based on phone type) and handle the scenario where the customer does not have a home phone in the database. Right now it's throwing an out of range exception if the customer does not have any phone numbers.

I've tried using the Where operator with a lambda expression to filter the phone type but it doesn't work:

<%# Eval("Phones.Where(p => p.PhoneTypeId == 2).PhoneNumber") %>

Solutions or links to any good articles on the subject would be much appreciated.