EF语句转换

shouzhi2007

1. SELECT u.ChineseName,u.Name,d.Name,t2.Name FROM dbo.Users u
   
2.    LEFT JOIN dbo.Depts d  ON u.DeptID = d.ID
   
3.    LEFT JOIN dbo.TitleUsers t ON u.ID = t.UserID
   
4.    LEFT JOIN dbo.Titles t2 ON t.TitleID = t2.ID
   
5.    ORDER BY t2.Name desc

复制代码

这语句怎么用

1. IQueryable

复制代码

写出来?

gdcrx

我没创建表测试，下面语句你看下生成的sql语句是否可行。

1.     var sel = from u in dbo.Users
   
2.             join d in dbo.Depts on u.DeptID equals d.ID into dept
   
3.             from d_d in dept.DefaultIfEmpty()
   
4.             join t in dbo.TitleUsers on u.ID equals t.UserID into title1
   
5.             from d_t in title1.DefaultIfEmpty()
   
6.             join t2 in dbo.Titles on d_t.TitleID equals t2.ID into tile2
   
7.             from d_t2 in tile2.DefaultIfEmpty()
   
8.             orderby d_t2.Name
   
9.             select new {
   
10.                 ChineseName = u.ChineseName,
    
11.                 Name=u.Name,
    
12.                 DeptName = (d_d.DeptID == null) ? string.Empty : d_d.Name,
    
13.                 TitleName = (d_t2.ID == null)? string.Empty : d_t2.Name
    
14.             };

复制代码