Hello I have a problem for binding to gridview...
Assume I have two table : Album and Photo each has 'Name' column (Assume they are the same name).
When I bind the Photo using Linq to Sql, I can reference the data like this DataBinder.Eval(Container.DataItem, "Name"); but if I want to have the Name of the Album is it possible to fetch that values as well.
I can use the join statement with alias name but because I am putting the data layer and presentation layer separately, I won't be able to use anonymous IQueryable type as a return value in the method.