title: Newlines get stripped in SQL after datatable update
body: <p>I have a datatable that gets modified by having the html stripped out. During the html strip if a <code>&lt;br&gt;</code>, <code>&lt;p&gt;</code> or <code>&lt;li&gt;</code> is encountered they are replace with <code>System.Environment.NewLine</code>. I am logging ever instance of the html strip process to a text file and the formatting looks fine in the log (all CRLF are preserved). However when the update method is called on the datatable and the data gets sent to the database the CRLF characters are all gone.</p>
  
  <p>Code snippet:</p>
  
  <pre><code>public static class HtmlStripper
  {
      static Regex _htmlRegex = new Regex("&lt;.*?&gt;", RegexOptions.Compiled);
      static Regex _liRegex = new Regex("&lt;li&gt;", RegexOptions.Compiled);
      static Regex _brRegex = new Regex("&lt;(br)?(BR)?\\s?/?&gt;\\s*", RegexOptions.Compiled);
      static Regex _pRegex = new Regex("&lt;/?[phPH].*?&gt;\\s*", RegexOptions.Compiled);
  
      public static string StripTagsRegexCompiled(string source)
      {
          string noPorH = _pRegex.Replace(source, System.Environment.NewLine);
          string noBr = _brRegex.Replace(noPorH, System.Environment.NewLine);
          string noLi = _liRegex.Replace(noBr, System.Environment.NewLine + "t- ");
          return _htmlRegex.Replace(noLi, string.Empty);
      }
  
  }
  </code></pre>