# Issue with LINQ / SQL - how to investigate

**URL:** https://talk.remobjects.com/t/issue-with-linq-sql-how-to-investigate/33817
**Category:** Data Abstract
**Tags:** net
**Created:** [August 17, 2026, 9:35am UTC](https://talk.remobjects.com/t/issue-with-linq-sql-how-to-investigate/33817 "2026-08-17T09:35:27Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![fvancrae](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/f/ad7895/32.png) [@fvancrae](https://talk.remobjects.com/u/fvancrae)
#### Post date: [August 17, 2026, 9:35am UTC](https://talk.remobjects.com/t/issue-with-linq-sql-how-to-investigate/33817/1 "2026-08-17T09:35:27Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![fvancrae](https://talk.remobjects.com/letter_avatar_proxy/v4/letter/f/ad7895/32.png) [@fvancrae](https://talk.remobjects.com/u/fvancrae)
#### Post date: [August 17, 2026, 12:50pm UTC](https://talk.remobjects.com/t/issue-with-linq-sql-how-to-investigate/33817/3 "2026-08-17T12:50:38Z")

</div>

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

Apologies!