How do you create a relational object using the LinqDataSource
Posted on 2009-04-19
I am trying to use the LinqDataSource in an ASP.net application. I have two tables that have a relation between each other through a field call MPI. I have setup the DataClass.dbml with the two tables and created an association between the two tables. I had expected that after I did that I could then see all fields from both tables when I dragged the LinqDataSource to the canvas. When I configured the LinqDataSource I only get the fields from the table that is selected. How can I access fields from both tables when using the LinqDataSource?