SqLiteOperationsAdapter.LoadSqliteValues: Property converters aren't being used if the property name is different to the column name

[smnplicity]

The key of ConvertibleColumnConverterDict is the SQLite column name, and the contains key check is on the property name. If these two differ e.g. via annotations, the converter does not get invoked.

Changing the lookup to use propertyColumn.Value appears to work:

if (tableInfo.ConvertibleColumnConverterDict.ContainsKey(propertyColumn.Value) && value != DBNull.Value)
{
    value = tableInfo.ConvertibleColumnConverterDict[propertyColumn.Value].ConvertToProvider.Invoke(value);
}

This issue was observed as a result of the DateTimeOffset converter required for Sqlite: dotnet/efcore#10784 (comment)

[borisdj]

Fixed with v6.5.3