c# left join linq
var query = from person in people
join pet in pets on person equals pet.Owner into gj
from subpet in gj.DefaultIfEmpty()
select new { person.FirstName, PetName = subpet?.Name ?? String.Empty };right outer join in linq sql
using (JoinEntities Context = new JoinEntities())
{
var rightOuterJoin = from d in Context.DepartmentMasters
join e in Context.EmployeeMasters on d.DepartmentId equals e.DepartmentId into emp
from employee in emp.DefaultIfEmpty()
select new
{
EmployeeCode = employee.Code,
EmployeeName = employee.Name,
DepartmentName = d.Name
};
Console.WriteLine("Employee CodetEmployee NametDepartment Name");
foreach (var data in rightOuterJoin)
{
Console.WriteLine(data.EmployeeCode + "tt" + data.EmployeeName + "t" + data.DepartmentName);
}
}Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
