跪求 SQL 转换LinQ 语句
select SortId,DataEditor.DepartmentId, sum(DEMoney)
from DataEditorMember
inner join DataEditor
on DataEditor.Id=DataEditorMember.DEId
inner join CashflowSort
on CashflowSort.Id= DataEditorMember.SortId and
CHARINDEX('1',CashflowSort.ParentStr)>0
and DataEditor.CreaterTime>'2010-07-01' and
DataEditor.CreaterTime<'2010-07-30' and DataEditor.DepartmentId='FBCW'
Group by SortId,DataEditor.DepartmentId
其中 createrTime 和 DepartmentId 是页面的查询语句 怎么转换成LinQ