SQLite issue: Invalid datatype: GUID

MasterCephus · Post by **MasterCephus** » Tue 18 Jan 2011 14:54

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?

StanislavK · Post by **StanislavK** » Thu 20 Jan 2011 14:18

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.

StanislavK · Post by **StanislavK** » Thu 07 Apr 2011 17:06

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