帮我将Sql转换为linq [英] Help me to convert Sql to linq

问题描述

嗨

select D.CommonName,D.CoursesFK,D.DepartmentDetailsFK,
D.ID,D.LegalName,C.LegalName as Courses,DD.CourseYear as DepartmentID  from Departments D 
 join Courses C on C.ID=D.CoursesFK
 left outer join DepartmentDetails DD on DD.ID=D.DepartmentDetailsFK;

推荐答案

尝试类似这样的方法:

Try something like this:

from dept in Departments
JOIN course in courses ON dept.CoursesFK equals course.ID
JOIN deptDetail in DepartmentDetails ON dept.DepartmentDetailsFK equals deptDetail.ID
select NEW
{
    dept.CommonName,
    dept.CoursesFK,
    dept.DepartmentDetailsFK,
    dept.ID,
    dept.LegalName,
    course.LegalName as Courses,
    deptDetail.Courseyear as DepartmentID
}

浏览以下站点并下载Linquer.它将SQL查询转换为Linq
http://www.sqltolinq.com/ [ ^ ]

go through below site and download Linquer. It converts SQL query to Linq
http://www.sqltolinq.com/[^]

尝试一下:

try this:

From D In Departments Join C in Courses ON C.ID equals D.CoursesFK Group Join DD in DepartmentDetails on DD.ID equals D.DepartmentDetailsFK
select NEW {    D.CommonName,    D.CoursesFK,    D.DepartmentDetailsFK,    D.ID,    D.LegalName,
    C.LegalName as Courses,    DD.Courseyear as DepartmentID
}

请参见下面的链接.
它将为您提供帮助.
链接1 [链接2 [ ^ ]

See below Link.
It Will HelpFul For you.
Link 1[^]
Link 2[^]

这篇关于帮我将Sql转换为linq的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！