title: Filtering by plain date SQL to Linq syntax
body: <p>I have the following SQL and result:</p>
  
  <pre><code>SELECT EventTime FROM Incidents
  -- RESULT --
  2015-10-20 00:00:00.000
  2015-10-20 05:00:00.000
  2015-10-20 05:50:00.000
  2015-10-20 07:00:00.000
  2015-10-20 09:00:30.000
  2015-10-21 05:00:00.000
  2015-10-21 06:10:00.000
  2015-10-22 09:10:00.000
  </code></pre>
  
  <p>I use the following SQL to filter by plain date (SQL 2014):</p>
  
  <pre><code>SELECT DISTINCT CONVERT (Date, [EventTime]) AS EventDate FROM Incidents
  -- RESULT --
  EventDate
  2015-10-20
  2015-10-21
  2015-10-22
  </code></pre>
  
  <p>So very easy in SQL. For LINQ I try the logic:</p>
  
  <pre><code>var q = db.TimeLines.Select(x =&gt; x.Time.Date).Distinct();
  // show it
  q.ToList().ForEach(x =&gt; { Console.WriteLine("EventDate: {0}", x); });
  </code></pre>
  
  <p>Breaks with: Additional information: The specified type member 'Date' is not supported in LINQ...</p>
  
  <p>...How to write the second SQL in LINQ?</p>