var docQuery = ProfilesContext.My_usr_profiles.Where(i=>i.Usr_profiles_id>=1).Select(i=>new{i.Usr_profiles_id,i.Usr_profiles_usr_id,i.Usr_profile_name}).ToList(); var query = dbContext.usr_mails.join(docQuery,m=>new{id1=m.mail_id,id2=m.mail_usr_id},n=>new{id1=n.Usr_profiles_id,id2=n.Usr_profiles_usr_id},(m,n)=>new{m.mail_id,m.mailer_name,n.profile_usr_name}).ToArray();
join
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)