I have an example in SQL how to use the same logic in Linq to Entity?
SELECT * FROM TABLE WHERE DATE BETWEEN STARTDATE AND ENDDATE