Hello! ๐
Thank you so much for sharing and maintaining such a great library!
Faced one problem when using SQLite database provider with EF and wonder if you could give suggestions on how to resolve it.
When using SQLite, decimal IDs are stored as "text" despite invocation of ConfigureDecimalIdTypes(). I believe that's because SQLite does not support DECIMALS with such high precision. When ID value is stored in the database, looks like ToString() generated method is used to convert number to a text database type:
public override string ToString()
{
return this.Value.ToString("0.#");
}
As a result, decimal value is stored something like this: 1098956916504943605256135935.0 (note the trailing ".0").
Now, when trying to call ToAlphanumeric() on that value, exception is thrown:
System.ArgumentException: The ID must be positive, have no decimal places, and consist of no more than 28 digits. (Parameter 'id')
Looks like it does not like trailing decimal place ".0".
How would you suggest to resolve this? Either not store decimal place in the database or modify ToAlphanumeric() to disregard it?
Thank you! ๐