System.Data.SQLite

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.

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?

I have attached the project that demonstrates the bug.

Thanks!

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.

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?

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.

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.

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.

I suspect the issue persists because the previous version was installed as part
of the setup for the designer components.

Ok, I am available to do other tests otherwise we close the ticket with version 1.0.87.0 final.

Thanks!
Fabio.

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.

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?

Yes, DbType Double is mapped to REAL.  Anyhow, it seems like the issue is
confirmed fixed.