Page 1 of 1

SQLite issue: Invalid datatype: GUID

Posted: Tue 18 Jan 2011 14:54
by MasterCephus
I have a database with a table in SQLite that has column of type GUID. In my mapping file, I have the type as "System.GUID" and the server data type as "GUID NOT NULL".

I am getting an exception that gives "Invalid datatype: GUID"

Everything seems to be appropriate. Can anyone give me help?

Posted: Thu 20 Jan 2011 14:18
by StanislavK
At the moment, the possible way of using GUIDs in LinqConnect models for SQLite is converting them to string. We are working on support for GUIDs, but cannot provide any timeframe for this.

Posted: Thu 07 Apr 2011 17:06
by StanislavK
We have implemented the proper support for GUID fields in LinqConnect models for SQLite. These changes are available in the latest 2.20.19 build of LinqConnect, which can be downloaded from
http://www.devart.com/linqconnect/download.html
(the trial and free versions only) or from Registered Users' Area (provided that you have an active subscription):
http://secure.devart.com/

For the detailed information about the fixes and improvements available in LinqConnect 2.20.19, please refer to
http://www.devart.com/forums/viewtopic.php?t=20706