This query works great:
var pageObject = (from op in db.ObjectPermissions
join pg in db.Pages on op.ObjectPermissionName equals page.PageName
where pg.PageID == page.PageID
select op).SingleOrDefault();
I get a new type with my 'op' fields. Now I want to retrieve my 'pg' fields as well, but
select op, pg).SingleOrDefault();
doesn't work.
How can I select everything from both tables so that they appear in my new pageObject type?