I did some more tests. The way it handles GUID between text and binary is screwed up.
When updating data, it will update as binary even if BinaryGUID is false. When selecting data, however, it tries to select it as plain text so nothing matches the query. Etienne From: mystery...@hotmail.com To: sqlite-users at mailinglists.sqlite.org Subject: RE: [sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows" Date: Sun, 31 May 2015 22:40:56 -0600 Oh. I see what you were trying to say. The error I was having was not because GUID isn't supported, but because it was trying to interpret the data as binary while it was stored as text, thus the request failed. I just tried creating a new table with a primary key of type 'uniqueidentifier', and adding data into it. It shows up as binary data. I also tried adding "binary guid=False" to the connection string, but this parameter doesn't have any effect. It still treats the column as binary. Etienne
