dt1 =Convert.ToDateTime(dt1.ToString(“yyyy-MM-dd”));
dt2 =Convert.ToDateTime(dt2.ToString(“yyyy-MM-dd”));
try
{
var query = from q in db.Employees
where EntityFunctions.TruncateTime(q.DOB) >= dt1
&& EntityFunctions.TruncateTime(q.DOB) <= dt2
select q;
var data = query.ToList();