Guid is serialized differently in sqlite for "normal" and autoid entries

ServiceStack.OrmLite Sqlite
1

Hi,
I have the following class and noted, that the “id” and the “landId” are serialized differently. That could be a problem, when I export the data and the guid are in different formats.
Is that behaviour by intention? Can I change that?

2022-02-28_10h29_00
2022-02-28_10h29_001100×379 14.3 KB

2022-02-28_10h29_14
2022-02-28_10h29_141463×116 26.8 KB

2

If you’re talking about [AutoId] that’s using the preferred Auto populated Guid Id for each RDBMS. You can change it by not using [AutoId] and populate it with Guid.NewGuid() when saving the record.

Otherwise OrmLite uses Type Converters to control how each Type is saved and hydrated from an RDBMS, which you can override with your own custom Type Converter implementation.

3

Hi,
in SqliteProvider is possible to force AutoId to store the Guid value in UpperCase?

Thanks

4

You can inherit SqliteGuidConverter with your own implementation that returns what you want in ToQuotedString() then register your custom Type Converter with:

SqliteDialect.Provider.RegisterConverter<Guid>(new MyCustomGuidConverter());