Override how Guid.ToString for Sqlite is implemented in SQL

[jogibear9988]

Is there a way, so I could override, how ToString() of a guid will be converted to SQL?

In Sqlite I need it to generate SQL like this:

    substr(hex(id), 1, 8)
    || '-' || substr(hex(id), 9, 4)
    || '-' || substr(hex(id), 13, 4)
    || '-' || substr(hex(id), 17, 4)
    || '-' || substr(hex(id), 21, 12)

[jogibear9988]

I could do it like this in SQLLiteQueryOptimizer, but is this the correct location?
And also I could not provide SQLiteDataProvider my own "SqliteOptimizer", without implementing also my own SQLiteDataProvider

[jogibear9988]

And also the SQLiteSqlOptimizer is sealed, so I need to copy the whole code

[MaceWindu]

literals generation logic stored in mapping schema. You need to register your generation logic using SetValueToSqlConverter method like here

[jogibear9988]

@MaceWindu but is this not the other direction, Guid to String? I need a string comparison of the stored guid in SQL.

I will create a pull with my change, if its okay

[sdanyliv]

I do not understand this logic. Why it is needed? Create your own extension method.

[jogibear9988]

because in SQLSever for example a guid could be converted to a string, in sqlite it could not