Devart Forums

Hello,

I have a problem with the sql generated because of my old version of interbase (XE 2 ... yeah I know), which does not understand the cast of parameters like :
select * from TEST_TABLE where TEST_ID = cast(:p0 as integer)

Dynamic SQL Error
SQL error code = -804
Data type unknown

Code :
var vQry : ILinqQueryable;
var vTest : ITestTableExpression;

vQry := From(vTest).Where(vTest.TestId = 5).Select();


Is there a workarround ? Can I changed the format of generated sql parameters avoiding "cast" ?

I use EntityDac 2.3.4 for RAD Studio 10.3

Thanks

To give you a detailed answer, we first need to look into code that exposes such behavior. Please send us a small code sample demonstrating the behavior, including the scripts for creating database objects, and your model (*.enml).