Edit Question - KnowledgeHub

Title Body

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. 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 < 10; i++) { var newRow = table.NewRow(); newRow[0] = date; table.Rows.Add(newRow); } return table; } Please can you tell me a workaround for this? Thanks!!!

Tags (comma-separated) Cancel