title: Sql queries in c# student attendance
body: <p>I have one table which has 6 columns id, Username, status,remarks, date, role and I need to make a custom api through which I need to find the number of days a student is present between two dates.</p>
  
  <p>Status is present/absent
  Role is teacher/Student</p>
  
  <p>I have tried to passed id, start date , end date to my router like
  HttpGet["{Id}/{startdate}/{enddate}"]
  But I can't pass date as this start and end date data type </p>
  
  <p>How should I write the methods in controller?</p>