LLBLGen 4.0 generates the following statement:

SELECT "a"."AK"           AS "Ak"
        FROM   "a" "b"
WHERE  (("a"."field" = :p1))
   AND rownum <= 100 

It does not work, since ion the where and in the select clause the table alias name should be used.

I was wondering about this issue, since I've never have seen similiar issues with LLBLgen before - was there a change? This query is based on the QuerySpec API. Usually I used Linq2Sql and have never seen such issues - is the code generation based on different implementations?

Is there any change to workaround this issue from user side?

Thanks for every help,

Matthias

Please post the minimal code possible, which produce this SQL.

Also: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7725