Issue with LINQ / SQL - how to investigate

Data Abstract
1

I have a relative simple DA schema which results in an exception

when performing a simple LINQ query

DA schema:

SELECT
kor_primkey, kor_datechanged,kor_userid, kor_pat_primkey,
kor_KortBtw1, kor_KortBtw2, kor_KortBtw3, kor_KortBtw4, kor_Totaal,
kor_datum, kor_brontype,kor_kortingtype,kor_status,kor_pak_primkey,
kor_typeuitwerking,kor_datumuitwerking,kor_rek_primkey,
kor_aantalvrk,kor_ReleaseId,
kor_apotheekid ,‘’ as kor_ApotheekNaam
FROM OffCloud.dbo.SavingsAccountAmount_officinalltest
WHERE {where}
{orderby}

LINQ query:

var kortingtest DataAdapter.GetTable<CloudEnabledDBData.cloudenabledrekening.Korting>();
var korrecordstest = kortingtest.ToDABindingList();

The exception is “Incorrect syntax near =” (i cannot upload screenshots, i can mail some details though)

By capturing the SQL in OnBeforeExecutingGetDataReader I see that the ‘where"’ disappeared

SELECT
kor_primkey, kor_datechanged,kor_userid, kor_pat_primkey,
kor_KortBtw1, kor_KortBtw2, kor_KortBtw3, kor_KortBtw4, kor_Totaal,
kor_datum, kor_brontype,kor_kortingtype,kor_status,kor_pak_primkey,
kor_typeuitwerking,kor_datumuitwerking,kor_rek_primkey,
kor_aantalvrk,kor_ReleaseId,
kor_apotheekid ,‘’ as kor_ApotheekNaam
FROM SavingsAccountAmount_officinalltest (1=1)

Is this still a bug in RO/DA?

3

Please ignore this post. It was a bug on my side.

Apologies!