Garbled Text in uniqueidentifier in SQLite Garbled Text in uniqueidentifier in SQLite sqlite sqlite

Garbled Text in uniqueidentifier in SQLite


Never mind, I figured out the work around.

It seems like the Sqlite store the Guid as binary data by default. And .net want it to be string.

So set the connection string to the sqlite database with the follow settings will fix the problem:

Data source=somefile;BinaryGUID=False;

refer to: http://www.connectionstrings.com/sqlite