title: Linq insert with nullable datetime column
body: <p>I am trying to do an insert with Linq and keep getting the sqlDateTime overflow error.</p>
  
  <p>I have a nullable DateTime field in the DB.</p>
  
  <p>I am using linq to sql and my class for the dateTime is:</p>
  
  <pre><code>[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_concern_DateTo", DbType="DateTime")]
  public System.Nullable&lt;System.DateTime&gt; concern_DateTo {
      get { return this._concern_DateTo; }
      set {
          if ((this._concern_DateTo != value)) {
              this.Onconcern_DateToChanging(value);
              this.SendPropertyChanging();
              this._concern_DateTo = value;
              this.SendPropertyChanged("concern_DateTo");
              this.Onconcern_DateToChanged();
          }
      }
  }
  </code></pre>
  
  <p>I have a JQuery datepicker that selects the date and I am checking that it is a dateTime:</p>
  
  <pre><code>DateTime PartC_DateTo = new DateTime();
  
  //'Date To' Part C
  //================
  if (txt_PartC_DateTo.Text != string.Empty) {
      DateTime.TryParse(txt_PartC_DateTo.Text, out PartC_DateTo);
  }
  </code></pre>
  
  <p>then when I am assigning I am using this code:</p>
  
  <pre><code>if (txt_PartC_DateTo.Text != string.Empty) {
      concern.concern_DateTo = PartC_DateTo;
  }
  </code></pre>
  
  <p>Then when I <code>submitChanges()</code>, the SQLDateTime error appears as I'm writing the exceptions to the screen for testing.</p>