/ Published in: C#
Note: An order operator in a subquery will be ignored. The main query controls ordering.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
var universe = from oa in context.vOfficeAddresses where oa.StateProvince == "Ontario" select oa; var query = from oa in universe oa, contact = (from c in context.Contacts where c.ContactID == oa.ContactID select c) }; var AddressesWithContacts = query.ToList();