SQL error when casting to double -------------------------------- Key: DNET-342 URL: http://tracker.firebirdsql.org/browse/DNET-342 Project: .NET Data provider Issue Type: Bug Components: Entity Framework support Reporter: Daniel Richter Assignee: Jiri Cincura
Casting a column/value to double produces an SQL error. E.g. the C# code ".Where(entity => entity.Value < 200.0)" (Value is System.Double)" is translated to SQL "WHERE Entity.Value < CAST (200 AS DOUBLE)" (My) Firebird only accepts "DOUBLE PRECISION" instead of "DOUBLE" After changing SqlGenerator.cs, ISqlFragment Visit(DbConstantExpression e), line 811, from "DOUBLE" to "DOUBLE PRECISION" it works. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider