How to write this query in linq to sql select COUNT(bookid) as Noofbook,IssueDate from Issuesofbook where IssueDate between @fromdate and @todate and Bookid=@bookid and ISACTIVE='1' group by IssueDate ...