In 4.2 (or 5 since i will upgrade soon), how can I do a direct entity update on a nullable field?

The field 'foo' is nullable therefore adding to it - remains 0 unless isnull() is used

sql required:

update tablename set foo = isnull(foo,0) + 1.50

current sql:

update tablename set foo = foo + 1.50

current llblgen which causes it to remain null:

fooinstance.Fields[(int)TableNameFieldIndex.Foo].ExpressionToApply = (TableNameFields.Foo+ 1.50);

thank you!

You should put the ISNULL in a DBFunctionCall. See the examples in the link.

Great! thank you.

In case anyone needs the code would be:

fooinstance.Fields[(int)TableNameFieldIndex.Foo].ExpressionToApply =  new DbFunctionCall("ISNULL({0},0) + {1}", new object[] { TableNameFields.Foo, 1.50 });

Nice! Thanks for sharing your solution.