dotConnect for Salesforce does not honor the Take operator (EF Core)
Posted: Wed 29 Aug 2018 15:44
I am in the process of trying the latest version of dotConnect for Salesforce (.NET 4.7.1, EF Core) and the following query does not seem to honor the Take operator:
I get the whole database back instead of just 10 items. Adding an OrderBy has no effect.
In the logs I see the following output:
Known limitation, or bug?
Code: Select all
return await _Context.Cases.AsNoTracking().Take(10).ToListAsync();
In the logs I see the following output:
Code: Select all
Microsoft.EntityFrameworkCore.Database.Command: Information: Executed DbCommand (2,778ms) [Parameters=[__p_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='60']
SELECT TOP(:__p_0) "c"."Id", "c"."CaseNumber"
FROM "Case" AS "c"