I'm using the dynamic query library and I'm trying to retrieve and access a single record from a one to many 'included' table/entity.
I have the following code:
var xresults = viv.tbl_user
.Include("tbl_pics")
.Include("tbl_user_bio")
.Include("tbl_province")
.Include("tbl_area")
.Where(qry, param);
GridView1.DataSource = xresults;
GridView1.DataBind();
tbl_pics contains many pics per user, one of which is flagged as a profile pic. How do I get the one record that is flagged and display in a listview along with the otehr profile info from other tables?
Thanks