Page 1 of 1
[Salesforce] Excepction during execute simple query.
Posted: Mon 24 Jun 2019 15:00
by cargt3
Hi,
I have simple linq query which use entity framework for salesforce.
Code: Select all
var contex = new ModelContext();
var aaaa = contex.Account.Where(x => x.Id == "0011l00000GNHtSAAX").ToList();
During execution i get error:
Code: Select all
Devart.Data.Salesforce.SalesforceException: 'You have an error in your SQL syntax at line 3, column 22: Unexpected symbol 'l00000GNHtSAAX'.'
I see that id is somehow cut to first letter
l but i dont know how to fix it.
Re: [Salesforce] Excepction during execute simple query.
Posted: Wed 26 Jun 2019 19:58
by Shalex
We cannot reproduce the issue at the moment. Please tell us:
1) the version (x.x.x) of your dotConnect for Salesforce
2) the EF version (e.g.: EF6)
3)
enable dbMonitor and specify the generated SQL
Re: [Salesforce] Excepction during execute simple query.
Posted: Mon 01 Jul 2019 14:15
by cargt3
1) 3.0.17.0
2) EF Core 2
3) For id = 0016E00000r6RIbQAM query its not generated . For id = E00000r6RIbQAM its generate (I remove unnecessary fields from select):
Code: Select all
SELECT "x"."Id"
FROM "Account" AS "x"
WHERE "x"."Id" = r6RIbQAM
but in c# i get error "Unknown column 'E00000r6RIbQAM". Its look like quotas are missing.
Re: [Salesforce] Excepction during execute simple query.
Posted: Wed 03 Jul 2019 19:20
by Shalex
Thank you for your report. We have reproduced the issue and are investigating it.
Re: [Salesforce] Excepction during execute simple query.
Posted: Thu 04 Jul 2019 07:01
by cargt3
Is any bypass exits for this problem like changing version of dotConnect or EF? I'm checking is dotConnect fits requirement of my company and i dont have many days of trial left.
Re: [Salesforce] Excepction during execute simple query.
Posted: Thu 04 Jul 2019 19:12
by Shalex
We have fixed the issue. A trial build with the fix is available at
https://www.dropbox.com/s/mxsh70awbo5hf ... l.exe?dl=0.
Re: [Salesforce] Excepction during execute simple query.
Posted: Thu 25 Jul 2019 14:40
by Shalex
New public build of dotConnect for Salesforce 3.4.805 is available for download.