Hi,

What is the problem with these DBFunctionCalls?

Dim exp As IExpression = New DbFunctionCall("getdate", Nothing)
Employee.Fields(EmployeeFields.LastUpdatedDate.FieldIndex).ExpressionToApply = exp

Dim exp2 As New Expression(EmployeeFields.NAME)
Employee.Fields(EmployeeFields.Code.FieldIndex).ExpressionToApply = exp2

Employee.Save

The first one update the field LastUpdatedDate with the server date The second one update the field Code with the contents of field Name (just for test)

When save the employee entity, the two fields(LastUpdatedDate,Code) are always saved null in db

Where is my mistake?

Please try to set the IsChanged of each field to true.

Also you can use the example in the docs in the Expressions in entity updates section found here: "Using the generated code -> Field expressions and aggregates"

Is Employee new or an existing entity?

Thanks Walaa, Otis

Employee object may be new or existing.

What I want to do is to save the CreationDate and LastUpdatedDate for Employee.

Walla suggestion works fine for update (set IsChanged to true), but doesn’t work for insert so I use GetDate() in database for insertion.

Is there any way to do it ByCode for insertion?

No, for insertion is not possible. However you could grab the values at code (that's more clean and clearly). In v2.5 Auditing was added, you can use such feature to grab log information in at a separate Auditor class.

Thanks, I will take a look at auditing mechanism soon as it is one of the requirement of the next project