[Salesforce] Excepction during execute simple query.

[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.

[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

[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.

[Shalex]

Thank you for your report. We have reproduced the issue and are investigating it.

[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.

[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.

[Shalex]

New public build of dotConnect for Salesforce 3.4.805 is available for download.