linq to entity 查询问题

Question

CreateOn 在数据库表中为smalldatetime类型 如何将下面sql 转换成linq to entity 形式 select count(0)+1 from Project_Hdr where ProjectNo='B' and CreateOn between '2013-02-19' and '2013-02-20'

Answer 1

var result=context.Project_Hdr.Where(n=>n.ProjectNo="B" && n.CreateOn.CompareTo(Convert.ToDateTime("2013-2-19"))>0 && n.CreateOn.CompareTo(Convert.ToDateTime("2013-2-20").AddDays(1))<0).Count()+1;