title: How to persist DateTime Kind while storing a datetime object into a data table?
body: <p>I’m facing an issue with storing the DateTime object into a datatable, it looses the Kind information set into it.For example if the DateTime.Kind is UTC, once I assign it to the datarow value it changes the Kind to Unspecified.Please find the code below.</p>
  
  <pre><code>public class LocalTimeToUtcConverter
      {
          public DateTime Convert(DateTime localDate)
          {
              var utcOffset = TimeZoneInfo.Local.GetUtcOffset(localDate);
  
              var utc = localDate.ToUniversalTime();
  
              return utc + utcOffset;
          }
      }
  
   [Test]
          public void Should_set_datetime_column_kind_to_utc()
          {            
              var localDate = new DateTime(2010, 11, 01, 00, 00, 00);
              Assert.That(localDate.Kind == DateTimeKind.Unspecified);
              var converter = new LocalTimeToUtcConverter();
              DateTime date = converter.Convert(localDate);
              Assert.That(localDate.Kind == DateTimeKind.Utc);
              var data = CreateTable(date);
              //Failes-Why????
              Assert.That(((DateTime)data.Rows[0].ItemArray[0]).Kind ==   DateTimeKind.Utc);
          }
  
          private DataTable CreateTable(DateTime date)
          {            
              DataTable table = new DataTable();            
              table.Columns.Add(new DataColumn("Date1", typeof(DateTime)));
  
              for (int i = 0; i &lt; 10; i++)
              {
                  var newRow = table.NewRow();
                  newRow[0] = date;
                  table.Rows.Add(newRow);
              }
  
              return table;
          }
  </code></pre>
  
  <p>Please can you tell me a workaround for this?</p>
  
  <p>Thanks!!!</p>