Why LinqToDB stores Guids in SQLite as binary (both with System.Data.SQLite and Microsoft.Data.Sqlite provider)?

[alexey-leonovich]

Hello.
I've noticed that by default LinqToDB stores in SQLite as binary (both with System.Data.SQLite and Microsoft.Data.Sqlite provider).
EF Core switched from BLOB to TEXT some time ago but motivation is not clear enough for me. @MaceWindu, you participated in that discussion - maybe you can clarify that? Is the only issue with Guid as BLOB was writing Guid to database via C# code and reading it from same database via Java? What are drawbacks of storing Guid as TEXT that make you not to follow EF Core command decision? Thank you.

[MaceWindu]

For historical reasons and backward compatibility. MS was provider introduced long after System.Data.Sqlite provider we supported initially. Plus it also used binary mapping for first versions