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

Last updated on DECEMBER 27, 2013

Applies to:

Oracle Data Provider for .NET - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms