System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 47f4bac575f91e3583569a314acef63dd8afd045
Title: Entity Data Model generator problem
Status: Closed Type: Code_Defect
Severity: Severe Priority: Medium
Subsystem: Convert Resolution: Fixed
Last Modified: 2013-05-29 16:02:20
Version Found In: 1.0.86.0
User Comments:
anonymous added on 2013-05-28 06:25:16:
I updated version System.Data.SQLite 1.0.86.0 (previous version 1.0.83.0) and when I update my entity data model I receive a lot of error "data type not supported:

Message	23	The data type 'longchar' is not supported; ...
Message	41	The data type 'double' is not supported; ...
Message	5	The data type 'bigint' is not supported; ...

I Have Visual Studio 2010 Framework 4.0 with sqlite-netFx40-setup-bundle-x86-2010-1.0.86.0.exe.

Thanks.

mistachkin added on 2013-05-28 08:11:18:
Are those messages warnings or errors?  Are you saying that these messages did
not show up when using version 1.0.83.0?  Do you have an example project that
demonstrates the issue?

anonymous added on 2013-05-28 09:05:00:
I have attached the project that demonstrates the bug.

Thanks!

anonymous added on 2013-05-28 09:06:06:
In the zip file there is example project and 2 screenshot: 
ModelGenerate 1.0.83.0.jpg -> Output after generation model with versione 1.0.83.0 
ModelGenerate 1.0.86.0.jpg -> Output after generation model with versione 1.0.86.0 

In the app.config, the path of test.db is absolute, is necessary change it for test. 

Thanks! 
Fabio.

mistachkin added on 2013-05-28 09:37:46:
I've found the issue and it has been fixed on trunk via check-in [4aa2360885].

Can you confirm the fix clears the issue for you?

anonymous added on 2013-05-28 10:29:46:
I'm sorry but I can not confirm because I haven't installed Visual Studio SDK.
I can confirm that the ticket is closed with the next release 1.0.87.

Thanks!
Fabio.

mistachkin added on 2013-05-28 11:32:05:
I've uploaded a new beta NuGet package for 1.0.87.0, here:

    https://www.nuget.org/packages/System.Data.SQLite.Beta

Please let me know if this works for you.

anonymous added on 2013-05-28 12:35:53:
The Error persist.

For Information:
I have update the package with command:
PM> Install-Package System.Data.SQLite.Beta

I've seen that after update I have the following situation in my project:
System.Data.SQLite -> Version 1.0.87.0
System.Data.SQLite.Linq -> Version 1.0.87.0
SQLite.Designer  -> Version 1.0.86.0 (???? it is normal?????)

Thanks.
Fabio.

mistachkin added on 2013-05-28 19:22:57:
I suspect the issue persists because the previous version was installed as part
of the setup for the designer components.

anonymous added on 2013-05-29 06:22:24:
Ok, I am available to do other tests otherwise we close the ticket with version 1.0.87.0 final.

Thanks!
Fabio.

mistachkin added on 2013-05-29 10:53:02:
I've uploaded a new setup that includes the fix, here:

https://system.data.sqlite.org/temporary/sqlite-netFx40-setup-bundle-x86-2010-1.0.87.0.exe

The previous version should be uninstalled prior to installing this version.

Please let me know if this clears the issue for you.

anonymous added on 2013-05-29 14:26:17:
Now the Entity Data Model is generated but there is difference in mapping data:
in verision 1.0.83.0 the DB Type real is mapped in c# double
in verision 1.0.87.0 the DB Type real is mapped in c# float

It is normal?

mistachkin added on 2013-05-29 16:02:20:
Yes, DbType Double is mapped to REAL.  Anyhow, it seems like the issue is
confirmed fixed.