I want Left join query using LInq to sql.
How can i convert below query into left joins query.
from customer_access in Adm.customer_accesses
join c in Adm.customers on customer_access.customer_no equals c.customer_no
join ur in Adm.user_roles on customer_access.user_id equals ur.user_id
join ar in Adm.app_roles on ur.role_id equals ar.role_id
select customer_access;
sql query is:
select * from customer_access ca left join customer c on ca.customer_no = c.customer_no left join user_roles ur on ca.user_id = ur.user_id left join app_roles ar on ur.role_id = ar.role_id
Thanks