Search orders between two dates in entity framework

See more:

search

entity-framework

i have a table
i want to search the list of orders between abc date to xyz date using entity framework
i used this
my table name is orders, column name is orderDate and datatype is date

// seacch between dates
protected void btn_Searchbydt_Click(object sender, EventArgs e)
{
string frmdate = txtfromdate.Text;
DateTimeOffset offsetfrmDate = DateTimeOffset.Parse(frmdate, null);
string todate = txtfromdate.Text;
DateTimeOffset offsettoDate = DateTimeOffset.Parse(todate, null);

var Query = (from o in db.orders
where EntityFunctions.DiffDays(offsetfrmDate, offsettoDate)
select o).ToArray();
griddetails.DataSource = Query;
griddetails.DataBind();
}


// Search by order id and this worked fine with me
protected void btn_SearchID_Click(object sender, EventArgs e)
{
var Query = (from o in db.orders
where (SqlFunctions.StringConvert((double)o.OrderUserID).Trim()) == txtsearch.Text
select o).ToArray();
griddetails.DataSource = Query;
griddetails.DataBind();
}