System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: d5ef4ca5195dde611ec46eb37d177eec6040642c
Title: sqlite data type "real" are mapped with c# "float"
Status: Closed Type: Code_Defect
Severity: Important Priority: Blocker
Subsystem: LINQ Resolution: Fixed
Last Modified: 2014-02-07 08:59:36
Version Found In: 1.0.90.0
User Comments:
anonymous added on 2014-01-27 16:14:34: (text/x-fossil-plain)
Hi,
in version 1.0.83 when I update model from db sqlite data type "real" are mapped with c# "double", in version 1.0.90 sqlite  data type "real" are mapped with c# "float".
This cause a lot of compile error about code that I have just write.

Any solution?

mistachkin added on 2014-01-27 23:02:28: (text/x-fossil-plain)
The current mapping of "REAL" appears to be to "DbType.Double", which should map
to the C# double type.

Do you have an example schema and/or code snippet that demonstrates the issue?

mistachkin added on 2014-01-27 23:23:51: (text/x-fossil-plain)
See also [2c630bffa7] and [47f4bac575].

anonymous added on 2014-01-28 08:31:25: (text/x-fossil-plain)
I attach a project to demonstrate this bug (if it is a bug).

Thanks!

mistachkin added on 2014-01-28 10:18:21: (text/x-fossil-plain)
This appears to be a duplicate of [c359fe1837].

anonymous added on 2014-01-28 13:45:19: (text/x-fossil-plain)
I have try to downgrade (1.0.83) ad upgrade (1.0.90) but the problem persist.
After downgrade the real are mapped with double, after upgrade the real are mapped with float.

Thanks!

anonymous added on 2014-01-28 14:06:14: (text/x-fossil-plain)
Additional information,
if after generation model I manually change the datatype i recive the following compile error:

Error	22	Error 2019: Member Mapping specified is not valid. The type 'Edm.Double[Nullable=False,DefaultValue=]' of member 'field_quantita' in type 'PrjModel.tPompa' is not compatible with 'SQLite.real[Nullable=False,DefaultValue=]' of member 'field_quantita' in type 'Prj.Store.tPompa'.

mistachkin added on 2014-01-28 22:44:12: (text/x-fossil-plain)
It seems that a similar issue exists with the Microsoft SQL Server provider:

http://forums.asp.net/p/1662958/4344066.aspx?Re+Error+2019+Edm+Double+is+not+compatible+with+SqlServer+real

mistachkin added on 2014-01-29 00:38:14: (text/x-fossil-plain)
Fixed on trunk via check-in [10e6d40e81].  This fix will be present in the
1.0.91.0 release.