Well, I need to create a query using the firebird "SUBSTR" function with linq, queryOver, or Criteria. I have option to create with HQL or SQL, but these would be my last options.
Does anyone have an idea? Here is an example of the query.
SELECT *
FROM LANCAMENTO
WHERE SUBSTR(LAN_CD_CONTA, 1, 13) = :paramCd_Conta