Create date in LINQ to Entities query

Use System.Data.Entity.DbFunctions.CreateDateTime to create new DateTime

var results = from s in MyContext.MyTable
              where DbFunctions.CreateDateTime(s.Year, s.Month, s.Day, 0, 0, 0).Value.CompareTo(fromDate) >= 0 &&
                    DbFunctions.CreateDateTime(s.Year, s.Month, s.Day, 0, 0, 0).Value.CompareTo(toDate) <= 0
              orderby s.Year, s.Month, s.Day
              select s;