将linq加入查询转换为SQL Inline加入查询

Question

我想将linq连接到简单的sql inline加入查询。

这是我的linq查询。

 public ProjectTaskList_Deleted GetTaskToBeDeletedByTaskID(int ProjectTaskID)
    {
        ProjectTaskList_Deleted list=null;
        try
        {
            using (var db = new Cubicle_EntityEntities())
            {
                list = (from a in db.ProjectTaskList_Deleted where a.ProjectTaskID == ProjectTaskID select a).FirstOrDefault();
            }
        }
        catch (Exception ex)
        {
        }
        return list;
    }

Answer 1

这是等效的SQL：

 select p.ProjectID ProjectID, p.ProjectName + ' - ' + p.ProjectCode as ProjectName
 from
 Projects p join ProjectTaskLists pl
 on p.ProjectID = pl.ProjectID
 where pl.IsDeliverable = true and p.CompanyId = @CompanyId 

其中 @CompanyId是参数。

Answer 2

这是SQL普通查询：

select p.ProjectID, p.ProjectName + ' - ' + p.ProjectCode as ProjectName from Projects p
Inner join ProjectTaskLists pl on  pl.ProjectID = p.ProjectID
where pl.IsDeliverable == true && p.CompanyId == @CompanyId