Hello, could someone help me with the below.
I would like to select all records in the email table when it exists in the customer and preferences table (left outer join?). This must return distinct records and in the form of list(of Emails).
Dim q = From e In db.Emails
Join c In db.Customers On e.email Equals c.EmailAddress
Join p In db.Preferences On c.CustID Equals c.CustID
Where p.condition = True
'where do I go from here? Then the list should be returned.
dim emaillist as new list(of Emails)
emailliist = q.tolist