How to set inner join in linq query

Question

I want to set inner join in linq query

Here is my code,

var JoinUsingMS = from emp in _productRepository.Table
   join address in _purchaseReminderRepository.Table
  on new { c1 = emp.VendorId, c2 = emp.Name } equals new { c1 = address.VendorId, c2 = address.Product } into bp_sm
   from c in bp_sm.DefaultIfEmpty()
   where emp.Published == true
   select emp;

From this query I am getting left join (track by doing debug). While I think so this query is perfect for inner join (reference link As Per This Solution) still output getting the left join

score 0 · Answer 1 · answered May 13 '21 at 06:28

Below updated query for the inner joins:

var JoinUsingMS = from emp in _productRepository.Table
   join address in _purchaseReminderRepository.Table
   on new { c1 = emp.VendorId, c2 = emp.Name } 
   equals new { c1 = address.VendorId, c2 = address.Product }
   where emp.Published == true
   select emp;

score 0 · Answer 2 · answered May 13 '21 at 23:43

Simple. Remove the DefaultIfEmpty line. That's what creates the left join clause:

var JoinUsingMS = 
    from emp in _productRepository.Table
    join address in _purchaseReminderRepository.Table
      on new { c1 = emp.VendorId, c2 = emp.Name } equals new { c1 = address.VendorId, c2 = address.Product } // into bp_sm
    // from c in bp_sm.DefaultIfEmpty()
    where emp.Published == true
    select emp;

How to set inner join in linq query

2 Answers2