How To Use Group Join In C# Linq.

Question

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.