Answers for "linq query left join"

SQL
1

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 };
Posted by: Guest on February-10-2021
2

linq join

var id = 1;
var query =
   from post in database.Posts
   join meta in database.Post_Metas on post.ID equals meta.Post_ID
   where post.ID == id
   select new { Post = post, Meta = meta };
Posted by: Guest on April-08-2020
0

linq left join

IQueryable<Job> jobs = (from j in _db.Jobs

                join jt in _db.JobTranslators on j.Id equals jt.JobId into jts
                from jtResult in jts.DefaultIfEmpty()

                join jr in _db.JobRevisors on jtResult.Id equals jr.JobId into jrs
                from jrResult in jrs.DefaultIfEmpty()


                join u in _db.Users on jtResult.UserId equals u.Id into jtU
                from jtUResult in jtU.DefaultIfEmpty()

                where jtUResult.Id == userId

                orderby j.Id

                select j).Concat(
                from j in _db.Jobs

                join jt in _db.JobTranslators on j.Id equals jt.JobId into jts
                from jtResult in jts.DefaultIfEmpty()

                join jr in _db.JobRevisors on jtResult.Id equals jr.JobId into jrs
                from jrResult in jrs.DefaultIfEmpty()

                join u in _db.Users on jrResult.UserId equals u.Id into jrU
                from jrUResult in jrU.DefaultIfEmpty()

                where jtUResult.Id == userId

                orderby j.Id

                select j
                ).Distinct()
Posted by: Guest on July-20-2021
0

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 Code\tEmployee Name\tDepartment Name");  
    foreach (var data in rightOuterJoin)  
    {  
        Console.WriteLine(data.EmployeeCode + "\t\t" + data.EmployeeName + "\t" + data.DepartmentName);  
    }  
}
Posted by: Guest on September-07-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language