Code: Select all
[Table(Name = "ORDER")]
public class OrderEntity
{
[Column(Name = "CREATED", DbType = "TIMESTAMP(6) WITH LOCAL TIME ZONE NOT NULL")]
public DateTimeOffset Created { get; set; }
}
Code: Select all
var result = _dataContext.Orders.Where(r => r.Created >= DateTimeOffset.Now.AddDays(-1)).ToList();
Code: Select all
System.NotSupportedException: 'Cannot use "TIMESTAMP(6) WITH LOCAL TIME ZONE" type value in "DateTimeOffset" type argument'
at Devart.Data.Linq.Engine.DbMethodCallConverter.CheckConversionToParameterType(SqlExpression argumentValue, Type parameterType)