|Title:||Entity Data Model generator problem|
|Last Modified:||2013-05-29 16:02:20|
|Version Found In:||126.96.36.199|
anonymous added on 2013-05-28 06:25:16:
I updated version System.Data.SQLite 188.8.131.52 (previous version 184.108.40.206) 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-220.127.116.11.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 18.104.22.168? 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 22.214.171.124.jpg -> Output after generation model with versione 126.96.36.199 ModelGenerate 188.8.131.52.jpg -> Output after generation model with versione 184.108.40.206 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 220.127.116.11, 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 18.104.22.168 System.Data.SQLite.Linq -> Version 22.214.171.124 SQLite.Designer -> Version 126.96.36.199 (???? 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 188.8.131.52 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-184.108.40.206.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 220.127.116.11 the DB Type real is mapped in c# double in verision 18.104.22.168 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.