NPGSQL link to SQL error

Data Abstract
1

Hello,

i recently updated RO/DA to version 10.0.0.1457 (using Npgsql Version 4.1.1). Since then linq queries using a where clause produce an invalid SQL.

Example:

var q = from r in linqLocalDataAdapter.GetTable<Mitarbeiter>()
             where r.MA_Loginname == username.ToLower() && r.MA_Austritt == null
             select r;

Produces the following SQL / Parameters:

SELECT "t0"."ma_loginname", ...
FROM "mitarbeiter" "t0" WHERE (("t0"."ma_loginname" = :) AND "t0"."ma_austritt" IS NULL) 

Parameter: 
p0 => test

As you can see, the parameter name p0 is missing in the sql.

With the previous installed RO/DA Version 8.3.91.1167 this worked without errors an generated the correct SQL string containing the parameter name p0.

2

Thanks, logged as bugs://83380

3

Hello

I would assume that you have modified your DataAbstract.daConfig file to be able to use Npgsql 4.1.1 . Could you upload it here or to support@?

4

Hi,

no, i didn’t modify the daConfig file. I only installed Npgsql via the nuget package. I know that the Schema Modeler could not connect to the database with this version but this was no problem at runtime.
For testing purposes i also tried it with Npgsql version 4.0.9, that didn’t work also.

Btw. the in RO/DA bundled Npgsql.dll has version 4.0.10 but the bundles daConfig file references version 4.0.9.

5

Hello

Unfortunately I was not able to reproduce this. For me parameter processing works as expected.

Could you create a testcase and send it to support@ ?

TIA

6

Hello Anton,

i could also not reproduce the error while creating a new RO/DA project and using NPGSQL. Therefore i migrated my existing code and classes to this newly created project and it works at excepted.

Maybe the problem only occurs when updating from such an “old” RO/DA Version (8.3.91.1167) to the current version (10.0.0.1457). But i have not time to further test this scenario.

Best regards, Daniel

7

bugs://83380 got closed with status cannotrepro.