ORA-00904: "TRUE": invalid identifier while using Contains
Posted: Mon 19 Aug 2019 13:20
Hi,
the ef core linq expression (using Devart.Data.Oracle.EFCore 9.7.805)
results to the generated sql
which throws the error 'ORA-00904: "TRUE": invalid identifier'. The Contains-Statement is not resolved.
The part of the sql-statement which is
should be
Democode can be downloaded here
the ef core linq expression (using Devart.Data.Oracle.EFCore 9.7.805)
Code: Select all
var groups = new List<string> { "abc" };
dbContext.Class1
.Select(one => new
{
one.Id,
InGroup = groups.Contains(one.GroupName),
})
.ToList();Code: Select all
SELECT "one"."Id", CASE
WHEN False = True
THEN 1 ELSE 0
END AS "InGroup"
FROM "Class1" "one"The part of the sql-statement which is
Code: Select all
WHEN False = TrueCode: Select all
WHEN "one"."GroupName" IN ('abc')