views:

12

answers:

0

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