Last post Nov 07, 2010 06:46 PM by sjnaughton
Nov 01, 2010 10:59 AM|gijigae|LINK
I have three tables, table1, table 2 and table3.
Table1 has PK_T1 and other tables also have PKs respectively.
Table1 has a foreign key relationship with table2 and tables2 has a relationship with table3.
Let's say Table1 has transactional records and it has DeptID and table2 contains department info with a UserID field.
Now, the table 3 is a user master.
When I view Table1/List.aspx, how can I show user names in the filter list?
Nov 01, 2010 11:15 AM|gmcoates|LINK
You should be able to query the database using an entity model adding the .Include("table2").Include("table3").ToList() for example to get all the data you need.
Nov 01, 2010 12:00 PM|Richthofen|LINK
You may need to set up a seperate field ... I'm assuming your data context has a partial class for data annotation. Here's how I would do it
public partial class Table1
public string User
Nov 07, 2010 03:15 PM|pvila|LINK
Does it work with entity datasource? I exposed
public partial class Padres
public Hijos HijoNuevo
Does it work with entity datasource? It seems not to visualize any table, I exposed
Nov 07, 2010 06:46 PM|sjnaughton|LINK
Hi Paullo, this does not work with EF, only L2S I usually use a computed column for this sort of thing.
Dynamic Data 4