Sql CAST

[program...@gmail.com]

Is there any methods i can use in lambdas that will map to a sql CAST?

We need to compare a string "123" to a number 123.

If there is any other way to do this than sql cast then that could work aswell.

[Jinq]

I don't think so. Jinq relies on JPA's JPQL for its queries, but JPQL's (and particularly Hibernate's) handling of types is pretty shaky, so they don't have proper support for casting. You would have to drop down to native queries for something like that.