title: Filter data according to Date in ASP.NET
body: <p>I have a database with two tables .</p>
  
  <p>First Table  <code>Card : CardId, Description</code>. - Keeps record of all the card available
  Second Table <code>RegistartionDt : RegistartionDtId, RegisteredDateTime</code> , <code>CardId</code>. keep data of the time and data a particular card is used.</p>
  
  <p>I want to make a search function that will search for the cards by the date . For example the user will chose from the drop-down menu the date. Start date and end date and search for the cards being used in that range.</p>
  
  <p>In my home controller I have an actionresult that takes the start date and the end date.</p>
  
  <p>And I am stuck here. Can you please guide me. What to do next ? How to connect the tables? 
  What ABOUT the view.</p>
  
  <p>I am new in asp.net and mvc.</p>