When reading a datetime (datetime2(3) in Microsoft SQL Server) an exception is raised
"Exception = [Could not convert database value to object member. Class name: TDatabaseSAPProductActivate Column name: DT_ExpiryDate Attribute name: ExpiryDate Database value: 2020-12-31 00:00:00.000]"
This record is previously created with that entity component and that was without problems.
[Entity]
[Table('SAPProductActivate')]
[Id('FId', TIdGenerator.SmartGuid)]
TDatabaseSAPProductActivate = class
private
[Column('ID_SAPProductActivated', [TColumnProp.Required])]
FId : TGuid;
FStore : TDatabaseStore;
FDepartment : Integer;
FPLU : Integer;
FExpiryDate : TDateTime;
FProduct : TDatabaseProduct;
public
property ID : TGuid read FId write FId;
[Association([], [])]
[JoinColumn('ID_Store', [])]
property Store : TDatabaseStore read FStore write FStore;
[Column('UN_Department')]
property DepartmentNr : Integer read FDepartment write FDepartment;
[Column('UN_PLU')]
property PLUNr : Integer read FPLU write FPLU;
[Column('DT_ExpiryDate', [], 3)]
property ExpiryDate : TDateTime read FExpiryDate write FExpiryDate;
[Association([], [])]
[JoinColumn('ID_Product', [])]
property Product : TDatabaseProduct read FProduct write FProduct;
end;
TMS Aurelius version 4.16 is used.