ExportSqlCE40: Export SqlCe uniqueidentifier column data to SQLite as binary about sqlcetoolbox HOT 7 OPEN

"BinaryGUID" is not a valid SQL Server Compact connection string keyword, correct.

There a many opinions about storage of Guids with SQLite - dotnet/efcore#15078

Is it possible make it to create inserts as binary

Anything is possible! But it would have to be an opt-in flag to avoid breaking changes - interested in doing a PR?

from sqlcetoolbox.

interested in doing a PR?

I'm afraid I don't have enough skills to try to make these code changes(

from sqlcetoolbox.

@alexey-leonovich Is your example above using the same guid value?

If not, could you provide an example that does?

from sqlcetoolbox.

@ErikEJ sorry, missed your question somehow.
Binary form X'a8828ddfef224d36935a1c66ae86ebb3' equals to text form 'DF8D82A8-22EF-364D-935A-1C66AE86EBB3'

from sqlcetoolbox.

How do you get from one to the other?

from sqlcetoolbox.

Guid guid = Guid.Parse("df8d82a8-22ef-364d-935a-1c66ae86ebb3");
var bytes = guid.ToByteArray();
var hex = new StringBuilder(bytes.Length * 2);
foreach (var b in bytes)
    hex.AppendFormat("{0:x2}", b);
var guidString = hex.ToString();

or simply via https://toolslick.com/conversion/data/guid

from sqlcetoolbox.

Thanks, I will consider implementing an option to use this format

from sqlcetoolbox.