sql - LINQ to Entities Right Join VB.NET -

sql - LINQ to Entities Right Join VB.NET -

i trying figure out how right bring together in vb.net have tried several different approaches neither works.

class="lang-vb prettyprint-override">dim query = in db.scll_label i.scll_transactiondate >= fromdate , i.scll_transactiondate <= todate bring together p in db.pt_mstr.where(function(pt) pt.pt_domain = "mueller") on i.scll_part equals p.pt_part bring together c in db.sclws_cfg.where(function(wk) wk.sclws_domain = "mueller") on i.scll_wsid equals c.sclws_id select new shiftadjustedmodel {.label = i, .transactiondate = i.scll_transactiondate, .partlength = p.pt_length, .partnetweight = p.pt_net_wt, .partdescription = p.pt_desc1, .parttolhigh = p.pt_tol_high, .parttype = p.pt_part_type, .partum = p.pt_um, .projcode = c.sclws_proj_code, .site = c.sclws_site}

output sql

class="lang-sql prettyprint-override">select [extent1].[scll_ticket] [scll_ticket], [extent1].[scll_domain] [scll_domain], [extent1].[scll_site] [scll_site], [extent1].[scll_part] [scll_part], [extent1].[scll_qty] [scll_qty], [extent1].[scll_weight] [scll_weight], [extent1].[scll_transactiondate] [scll_transactiondate], [extent1].[scll_transactiontime] [scll_transactiontime], [extent1].[scll_shift] [scll_shift], [extent1].[scll_pcs_bundle] [scll_pcs_bundle], [extent1].[scll_bundle_lift] [scll_bundle_lift], [extent1].[scll_cust] [scll_cust], [extent1].[scll_wsid] [scll_wsid], [extent1].[scll_userid] [scll_userid], [extent1].[scll_remarks] [scll_remarks], [extent1].[scll_calc_weight] [scll_calc_weight], [extent1].[scll_total_feet] [scll_total_feet], [extent1].[scll_tolerance] [scll_tolerance], [extent1].[scll_drawlite_factor] [scll_drawlite_factor], [extent1].[scll_total_tare] [scll_total_tare], [extent1].[scll_tare_detail] [scll_tare_detail], [extent1].[scll_out_of_tolerance] [scll_out_of_tolerance], [extent1].[scll_tolerance_low] [scll_tolerance_low], [extent1].[scll_tolerance_high] [scll_tolerance_high], [extent1].[scll_std_weight] [scll_std_weight], [extent2].[pt_length] [pt_length], [extent2].[pt_net_wt] [pt_net_wt], [extent2].[pt_desc1] [pt_desc1], [extent2].[pt_tol_high] [pt_tol_high], [extent2].[pt_part_type] [pt_part_type], [extent2].[pt_um] [pt_um], [extent3].[sclws_proj_code] [sclws_proj_code], [extent3].[sclws_site] [sclws_site] [dbo].[scll_label] [extent1] inner bring together [dbo].[pt_mstr] [extent2] on [extent1].[scll_part] = [extent2].[pt_part] inner bring together [dbo].[sclws_cfg] [extent3] on [extent1].[scll_wsid] = [extent3].[sclws_id] ([extent1].[scll_transactiondate] >= @p__linq__0) , ([extent1].[scll_transactiondate] <= @p__linq__1) , ('mueller' = [extent2].[pt_domain]) , ('mueller' = [extent3].[sclws_domain])

if utilize query

class="lang-vb prettyprint-override">dim query = in db.scll_label i.scll_transactiondate >= fromdate , i.scll_transactiondate <= todate grouping bring together p in db.pt_mstr.where(function(pt) pt.pt_domain = "mueller") on i.scll_part equals p.pt_part parts = grouping grouping bring together c in db.sclws_cfg.where(function(wk) wk.sclws_domain = "mueller") on i.scll_wsid equals c.sclws_id workstations = grouping p in parts.defaultifempty c in workstations.defaultifempty select new shiftadjustedmodel {.label = i, .transactiondate = i.scll_transactiondate, .partlength = p.pt_length, .partnetweight = p.pt_net_wt, .partdescription = p.pt_desc1, .parttolhigh = p.pt_tol_high, .parttype = p.pt_part_type, .partum = p.pt_um, .projcode = c.sclws_proj_code, .site = c.sclws_site}

i output

class="lang-sql prettyprint-override">select [extent1].[scll_ticket] [scll_ticket], [extent1].[scll_domain] [scll_domain], [extent1].[scll_site] [scll_site], [extent1].[scll_part] [scll_part], [extent1].[scll_qty] [scll_qty], [extent1].[scll_weight] [scll_weight], [extent1].[scll_transactiondate] [scll_transactiondate], [extent1].[scll_transactiontime] [scll_transactiontime], [extent1].[scll_shift] [scll_shift], [extent1].[scll_pcs_bundle] [scll_pcs_bundle], [extent1].[scll_bundle_lift] [scll_bundle_lift], [extent1].[scll_cust] [scll_cust], [extent1].[scll_wsid] [scll_wsid], [extent1].[scll_userid] [scll_userid], [extent1].[scll_remarks] [scll_remarks], [extent1].[scll_calc_weight] [scll_calc_weight], [extent1].[scll_total_feet] [scll_total_feet], [extent1].[scll_tolerance] [scll_tolerance], [extent1].[scll_drawlite_factor] [scll_drawlite_factor], [extent1].[scll_total_tare] [scll_total_tare], [extent1].[scll_tare_detail] [scll_tare_detail], [extent1].[scll_out_of_tolerance] [scll_out_of_tolerance], [extent1].[scll_tolerance_low] [scll_tolerance_low], [extent1].[scll_tolerance_high] [scll_tolerance_high], [extent1].[scll_std_weight] [scll_std_weight], [extent2].[pt_length] [pt_length], [extent2].[pt_net_wt] [pt_net_wt], [extent2].[pt_desc1] [pt_desc1], [extent2].[pt_tol_high] [pt_tol_high], [extent2].[pt_part_type] [pt_part_type], [extent2].[pt_um] [pt_um], [extent3].[sclws_proj_code] [sclws_proj_code], [extent3].[sclws_site] [sclws_site] [dbo].[scll_label] [extent1] left outer bring together [dbo].[pt_mstr] [extent2] on ('mueller' = [extent2].[pt_domain]) , ([extent1].[scll_part] = [extent2].[pt_part]) left outer bring together [dbo].[sclws_cfg] [extent3] on ('mueller' = [extent3].[sclws_domain]) , ([extent1].[scll_wsid] = [extent3].[sclws_id]) ([extent1].[scll_transactiondate] >= @p__linq__0) , ([extent1].[scll_transactiondate] <= @p__linq__1)

i want right outer bring together on 2 tables translated left outer join. if start tables right bring together lot of posts have suggested weird sql using cross joins , unions instead of right join.

sql vb.net linq