System.Data.SQLite

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?

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?

See also [2c630bffa7] and [47f4bac575].

I attach a project to demonstrate this bug (if it is a bug).

Thanks!

This appears to be a duplicate of [c359fe1837].

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!

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'.

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

Fixed on trunk via check-in [10e6d40e81].  This fix will be present in the
1.0.91.0 release.