|Title:||Entity Data Model generator problem|
|Last Modified:||2013-05-29 16:02:20|
|Version Found In:||184.108.40.206|
anonymous added on 2013-05-28 06:25:16:
I updated version System.Data.SQLite 220.127.116.11 (previous version 18.104.22.168) 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-22.214.171.124.exe. Thanks.
mistachkin added on 2013-05-28 08:11:18: (text/x-fossil-plain)
Are those messages warnings or errors? Are you saying that these messages did not show up when using version 126.96.36.199? Do you have an example project that demonstrates the issue?
anonymous added on 2013-05-28 09:05:00: (text/x-fossil-plain)
I have attached the project that demonstrates the bug. Thanks!
anonymous added on 2013-05-28 09:06:06: (text/x-fossil-plain)
In the zip file there is example project and 2 screenshot: ModelGenerate 188.8.131.52.jpg -> Output after generation model with versione 184.108.40.206 ModelGenerate 220.127.116.11.jpg -> Output after generation model with versione 18.104.22.168 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: (text/x-fossil-plain)
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: (text/x-fossil-plain)
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: (text/x-fossil-plain)
I've uploaded a new beta NuGet package for 22.214.171.124, 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: (text/x-fossil-plain)
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 126.96.36.199 System.Data.SQLite.Linq -> Version 188.8.131.52 SQLite.Designer -> Version 184.108.40.206 (???? it is normal?????) Thanks. Fabio.
mistachkin added on 2013-05-28 19:22:57: (text/x-fossil-plain)
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: (text/x-fossil-plain)
Ok, I am available to do other tests otherwise we close the ticket with version 220.127.116.11 final. Thanks! Fabio.
mistachkin added on 2013-05-29 10:53:02: (text/x-fossil-plain)
I've uploaded a new setup that includes the fix, here: https://system.data.sqlite.org/temporary/sqlite-netFx40-setup-bundle-x86-2010-18.104.22.168.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: (text/x-fossil-plain)
Now the Entity Data Model is generated but there is difference in mapping data: in verision 22.214.171.124 the DB Type real is mapped in c# double in verision 126.96.36.199 the DB Type real is mapped in c# float It is normal?
mistachkin added on 2013-05-29 16:02:20: (text/x-fossil-plain)
Yes, DbType Double is mapped to REAL. Anyhow, it seems like the issue is confirmed fixed.