title: Out-of-range Datetime issue using LINQtoSQL
body: <p>Here is a snippet of my  model:</p>
  
  <pre><code>* SQL Server *
  
  Event
  -----
  Id (int, PK) NOT NULL
  Title (varchar(100)) NULL
  LastModified (datetime) NULL
  
  EventDates
  ----------
  Id (int, PK) NOT NULL
  StartDate (datetime) NULL
  EndDate (datetime) NULL
  
  * C# *
  
  Event
  -----
  public int Id
  public string Title
  public DateTime LastModified
  
  EventDates
  ----------
  public int Id
  public DateTime StartDate
  public Datetime EndDate
  </code></pre>
  
  <p>The <code>LastModified</code> field has been in the database since its creation.  I have been saving it's value when I save an event, but I want to display it in a table, so I changed up my Event repository's <code>GetEvents</code>'s return value:</p>
  
  <pre><code>return (from e in GetDbEvents()
                  select new Event
                  {
                      // Miscellaneous fields..
                      LastModified = e.LastModified.GetValueOrDefault() // Shiny new code
                  });
  </code></pre>
  
  <p>When I call this now, I get yelled at:</p>
  
  <pre><code>The conversion of a char data type to a datetime data type 
  resulted in an out-of-range datetime value.
  </code></pre>
  
  <p>If I strip down the above code to this, it still doesn't help and I get the same error if I attempt to enumerate over the result:</p>
  
  <pre><code>var test = (from e in _db.Events
                      select e.LastModified.GetValueOrDefault());
  </code></pre>
  
  <p>As a test, I did the same statement for my <code>EventDates</code> table (again, with 2 datetime columns):</p>
  
  <pre><code> var test4 = (from ed in _db.EventDates
                       select new EventDate
                       {
                           StartDate = ed.StartDate.GetValueOrDefault(),
                           EndDate = ed.EndDate.GetValueOrDefault()
                       });
  </code></pre>
  
  <p>This works fine, of course.  No errors when I enumerate, all values are correct.</p>
  
  <p>I should point out that some <code>LastModified</code> values in the <code>Events</code> table are <code>NULL</code> while all values in <code>EventDates</code> are populated with data.</p>
  
  <h2>Edit</h2>
  
  <p>My  main question is why does <code>Events</code> give me out-of-range issues and <code>EventDates</code> does not, even though the model is quite similar?</p>