title: Linq query using only year part of datetime
body: <p>One of the column in my sqlserver table is datetime. In the where clause I have query just by the year (not month and date). I have to do it in LINQ using C#. Please let me know how could do it.</p>
  
  <p>For example if the following are the values in the table</p>
  
  <p>02/12/2010
  07/14/2011
  11/15/2012</p>
  
  <p>and if I query by '2011', only the middle row should be fetched.</p>
  
  <p>Thanks</p>