Skip to content

Wrong GUID to string conversion with SQLite BinaryGuid=False #2110

Closed
@oskarb

Description

@oskarb

Before NH 5.2, conversion from GUID to string (eg. entity.GuidProperty.ToString()) inside sqlite used a simple cast. This worked if BinaryGuid=False had been specified in the connection string.

Example SQL

    select
        cast(entity0_.Id as char) as col_0_0_ 
    from
        Entity entity0_

Following the fix for #1151 the conversion from GUID to string inside sqlite is now based on a sequence of substr() and hex(). This gives the correct result if BinaryGuid=True (the default), but not if BinaryGuid=False. This is a regression in NH 5.2 (seems undocumented).

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions