I am using a DynamicData - Entity project. I have added a DynamicDataManager with AutoForeignKeys = true and also added a EntityDataSource with an include to the associated table.
<asp:DynamicDataManager ID="DynamicDataManager1" runat="server" AutoLoadForeignKeys="true" >
<asp:DataControlReference ControlID="gvContact" />
<asp:EntityDataSource ID="EDS1" runat="server"
The contacts table has many to one relationship with the Ref_Values and Ref_States table were it shoud retrieve a "text" value for the job title and state.
When the page is ran the gridview returns the integer value that is in the DonorContacts table not the foreign key value.
I have ensured that the relationship exist and that all tables have a primary key. Also if I set the scaffold to true in the global.asax file and view the DonorContacts table the columns in question display the expected data, not the int.
I can get the correct value by using
View Complete Post