Linq from C# to VB.net -

i'm attemping c# linq expression, not seem work

c#

var v = (from in dc.chatprivatemessagemasters                      join b in dc.chatprivatemessagedetails on a.emailid equals b.masteremailid cc                      c in cc                      (c.masteremailid.equals(fromid) && c.chattoemailid.equals(toid)) || (c.masteremailid.equals(toid) && c.chattoemailid.equals(fromid))                      orderby c.id descending                      select new                      {                          username = a.username,                          message = c.message,                          id = c.id                      }).take(take).tolist(); 

vb

dim v = (from in dc.chatprivatemessagemasters _ join b in dc.chatprivatemessagedetails on a.emailid equals b.masteremailid _ cc _ c in cc (c.masteremailid.equals(fromid) andalso c.chattoemailid.equals(toid)) orelse (c.masteremailid.equals(toid) andalso c.chattoemailid.equals(fromid)) _ order c.id descending _ select new { _     .username = a.username, _     .message = c.message, _    .id = c.id _ }).take(take).tolist() 

i received error 'into' message: ')' expected

any idea?

// update database structure

for starters, don't need group join (the into part of join clause), considering flatten (and don't left outer join example).

your c# query can be:

var query =     (from m in dc.chatprivatemessagemasters     join d in dc.chatprivatemessagedetails on m.emailid equals d.masteremailid     (d.masteremailid == fromid && d.chattoemailid == toid)        || (d.masteremailid == toid && d.chattoemailid == fromid)     orderby d.id descending     select new     {         m.username,         d.message,         d.id     }).take(take).tolist(); 

and vb.net equivalent of is:

dim query =     (from m in dc.chatprivatemessagemasters     join d in dc.chatprivatemessagedetails on m.emailid equals d.masteremailid     (d.masteremailid = fromid andalso d.chattoemailid = toid)     orelse (d.masteremailid = toid andalso d.chattoemailid = fromid)     order d.id descending     select m.username, d.message, d.id     take take).tolist