Mukesh Kumar Tiwari

Mukesh Kumar Tiwari

  • 1.2k
  • 1k
  • 213.2k

How To Use Group Join In C# Linq.

Jun 3 2017 6:46 AM
Hi To All, 
here below is the query in linq(VB), but i want the same query in linq(c#). But when i use group join like below code, i get error. means i am not able to write group join like below in c# linq. Please help me out if any body know about it.
 
Thanks. 
 
This is query in linq(VB). 
 
Dim categorymaster =
(From cm In dbsession.Query.All(Of category_master)()
Group Join ss In dbsession.Query.All(Of shortcutseq)()
On ss.ITEM_ID Equals cm.CATEGORY_ID Into isl = Group
From islist In isl.DefaultIfEmpty
Group Join im In dbsession.Query.All(Of item_master)()
On im.CATEGORY_ID Equals cm.CATEGORY_ID Into cti = Group
From ctilist In cti.DefaultIfEmpty
Group Join id In dbsession.Query.All(Of item_detail)()
On ctilist.ITEM_ID Equals id.ITEM_ID Into il = Group
From ilist In il.DefaultIfEmpty
Where ilist.STATUS = 1 And ilist.SHORTKEY = 1 And (islist Is Nothing Or (islist.SEQ_TYPE = "C" And islist.COMPANY_ID = 1
 
/====
Here i want this like.
 
var quesrResult = (from  A in dbsession.query.all<POS_BILL.model.category_master>()
                              Group Join B ......
 
But not able to write group join..???
 
 
Thanks. 
 

Answers (1)