public void DateTimeKindIsPreservedTest()
{
// Should work for UTC time
DateTime utcDate = new DateTime(2022, 5, 26, 0, 0, 0, DateTimeKind.Utc);
Expression <Func <TestDocument, bool> > expr = a => a.StartDate <= utcDate;
string sql = SqlTranslator.TranslateExpression(expr.Body);
Assert.AreEqual("(a[\"StartDate\"] <= \"2022-05-26\")", sql);
// Should work for local time
DateTime localDate = new DateTime(2022, 5, 26, 0, 0, 0, DateTimeKind.Local);
expr = a => a.StartDate <= localDate;
sql = SqlTranslator.TranslateExpression(expr.Body);
Assert.AreEqual("(a[\"StartDate\"] <= \"2022-05-26\")", sql);
}
private void DoTranslate <R>(Expression <Func <BenchmarkDocument, R> > expression)
{
SqlTranslator.TranslateExpression(expression.Body);
}
