LINQ TO ENTITY Generates SQL Query Incorrectly Using French Culture Context (Doc ID 1610722.1)

Last updated on MARCH 24, 2022

Applies to:

Symptoms

LINQ to Entity generated SQL query in a french culture context : decimal constant in select list include a comma (french decimal separator) instead of a period (culture invariant separator), result is an incorrect SQL query.


Invariant Culture

Query:

SELECT 3.1415 AS "C1" FROM "BugDemos" "Extent1"

Result:

3.1415

French Culture

Query:

SELECT 3,1415 AS "C1" FROM "BugDemos" "Extent1"

Result:

1415

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.