The question is not so clear but I have optimized some thing from that,
My question is that why on the earth you want to accomplish the things using C# and Linq rather then applying Sql Query directly,
See the article for more info.
http://www.plus2net.com/sql_tutorial/between-date.ph[
^]
Please
vote and
Accept Answer if it Helped.