EntityDac 3.2.0 and Firebird 2.0.7
- EntityDac 3.2.0
- Firebird 2.0.7
- IBDAC 8.3.0
Expression:
From(ti).Where(ti.TRANSID = AId).OrderBy(ti.ID).Select();
Result:
SELECT t1.ID ID, t1.TRANSID TRANSID, t1.ITEMCODE ITEMCODE, t1.OPIS OPIS, t1.OPISDOD OPISDOD, t1.KWOTA KWOTA, t1.SZTUKI SZTUKI, t1.WAGA WAGA, t1.WAGAB WAGAB, t1.IDTYPU IDTYPU FROM TRANS_ITEMS t1 WHERE t1.TRANSID = cast (:p0 as INT64) ORDER BY t1.ID
1. Linq parameter is wrongly translated into SQL.
2. :p0 will suffice
3. INT64 is not recognized by the server should be BIGINT
Do I need some dialect configuration?
I'm trying to set the dialect as Firebird like this:
Data Provider=IBDAC;SQL Dialect=Firebird;Data Source=localhost;User ID=SYSDBA;Password=***;Client Library=fbclient.dll;Database=d:\some.FDB;Port=3050
Is this bug or I'm doing something wrong? Documentation for EntityDac is very limited :/