|Title:||sqlite data type "real" are mapped with c# "float"|
|Last Modified:||2014-02-07 08:59:36|
|Version Found In:||220.127.116.11|
anonymous added on 2014-01-27 16:14:34:
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 18.104.22.168 release.