Hi Frans,

As I read above, working with the CONVERT sql-function in combi with DbFunctionCall, is/was a little problematic. Is this already solved in the current release ?

grtz, Danny

Try to derive from the DBFunctionCall class and override the ToQueryText method.

OK, so this not possible in a standard way using the DbFunctionCall class ? What I meant with CONVERT(VARCHAR(x), y) was a Select statement like :

SELECT CONVERT(BIGINT, dbo.Transaction.TransactionId) AS Id FROM dbo.Transaction

I don't think it's possible in the time being with the use of DBFunctionCall.