The point I'm trying to make is not about whether GUID gets stored as binary or text... but rather that currently it's not working at all.
There's no reason why GUIDs shouldn't be supported and should crash when trying to do an update. Etienne > From: sqlite at mistachkin.com > To: sqlite-users at mailinglists.sqlite.org > Date: Sun, 31 May 2015 12:41:24 -0700 > Subject: Re: [sqlite] LINQ to SQLite Cannot Update: "Store update, insert, > or delete statement affected an unexpected number of rows" > > > Etienne Charland wrote: > > > > When defining a column as "uniqueidentifier" in SQLite, it still stores > the > > data as text. It would be the .NET provider's job to convert it back and > > forth to Guid. > > > > This depends on the value of the BinaryGUID connection string property. You > might want to experiment with setting this property to false (it defaults to > true). > > -- > Joe Mistachkin > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
