Firstly I'm not too sure how to use the SQL BETWEEN function in the first place but what I'm hoping to do is take two user textbox entries (these will be dates) from my frontend listview control and filter the data to be shown in the listview grid on these values through my Linq select query, i.e. I think the SQL would be something like:
WHERE order_date between to_date ('22/03/2009', 'dd/MM/yyyy')
AND to_date ('22/04/2009', 'dd/MM/yyyy');
So can this be done through Linq?