Databinding multiple tables linq query to gridview?

Question

My question is how can I display a linq query in a gridview that has data from multiple tables AND allow the user to edit some of the fields or delete the data from a single table?

I'd like to do this with either a linqdatasource or a linq query. I'm aware I can set the e.Result to the query on the selecting event. I've also been able to build a custom databound control for displaying the linq relations (parent.child).

However, I'm not sure how I can make this work with delete? I'm thinking I may need to handle the delete event with custom code.

Answer 1

Okay, I can use a template field to display some of the fields I need:

      <asp:TemplateField HeaderText="header">
            <ItemTemplate>
            <%#Eval("object.subobject") %>
            </ItemTemplate>
      </asp:TemplateField>

Now, I remember I had to create custom bound field types so that I could edit these but in this case that is not required.

So, in this case I think I'm good to go when using the linqdatasource and the subobjects. But, what if I wanted to add delete for a query that returned an anonymous type?