Hi,

I need to update one field using a db function call:

UPDATE some_table SET some_field= ... , last_modified=current_timestamp ,... WHERE ....

Using the SaveEntityCollection. How can I Apply that ?

Best Regards, MiloszeS

You can SetExpression on the entityfield, which can accepts a DBFunctionCall object.

Something like:

employee.Fields[(int)EmployeeFieldIndex.Salary].SetExression( new DBFunctionCall("GetCurrentTimeStamp()", 
    new object[] {}"));

empCollection.Add(employee);
adapter.SaveEntityCollection(empCollection);

Great - it works

Is it possible to call a function

current_timestamp

without brackets

current_timestamp()

using a standard LLBLGen methods or should I inherit from DbFunctionCall?

I'm using postgresql. The function without brackets has a default precision which is required by my client.

You can subclass dbfunction call and override ToQueryText, you can also use a trick:

employee.Fields[(int)EmployeeFieldIndex.Salary].SetExression( new DBFunctionCall("current_timestamp{0}",
    new object[] {string.Empty}"));

this will trick the dbfunctioncall the function is pre-formatted, so it won't append () itself, but there's no preformatting going on, you append an empty string