Hi I have a query like this: SELECT cp.pn_id, pn.pn_name, pt.pt_id, pt.pt_name, ps.ps_value,po.po_option,ps.ps_intvalue, ps_datevalue FROM ContentProperties cp inner join PropertyNames pn on cp.pn_id = pn.pn_id inner join PropertyTypes pt on pt.pt_id = pn.pt_id inner join PropertySelections ps on ps.ps_id = cp.ps_id left join PropertyOptions po on po.po_id = ps.po_id WHERE cp_type = 'DO' AND id = 40063 I found how to do the joins: var properties = from cp in dc.ContentProperties join pn in dc.PropertyNames
Read More...