How to search between two dates in LINQ to Entity?

Question

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  

Answer 1

I'm assuming C#.

DateTime startDate=bla; DateTime endDate=blabla; using(var db=new MyDataContext()) {     var filteredData=db.TABLE.Where(t => t.DATE > startDate && t.DATE < endDate);     //... }