lightswitch multi-table query -


i'm new lightswitch. have following data:

  1. tblcontent.subjectid
  2. tblcontent.sectionid
  3. tblsection.sectionid
  4. tblsection.sectiontitle
  5. tblpagesection.sectionid
  6. tblpagesection.pageid
  7. tblpage.pageid
  8. tblpage.pagetitle

i need display of sectiontitle/pagetitle pairs particular subjectid, user has selected on previous page (so i'd passing subjectid parameter).

i have obvious relationships set between tables in database (joining on sectionid , pageid).

can using lightswitch query designer? can't find examples of using lightswitch query designer join many tables. if can't use lightswitch query designer, best alternative approach?

i'm writing html client, if makes difference.

it seems can either use view if have database access, or else create custom wcf ria service described in this article.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -