title: Comparing two dates in LINQ to SQL
body: <p>I have a database with a table named meeting. Meeting dates are stored in this table using the following format: <code>May 2nd 2011</code> is (for example) formatted as <code>5/2/2011</code>.</p>
  
  <p>My requirement is to get the meetings between two dates (say, 4/25/2011 and 5/2/2011) and to write a query comparing a date with these two dates. Does it compare like 4/25/2011 &lt; 4/26/2011?  How does the comparison take place?</p>
  
  <p>I am using SQL Server 2008 and LINQ to SQL queries.</p>