NH-3426 - Wrong result when converting Guid to string

[nhibernate-bot]

Oskar Berggren created an issue — 18th March 2013, 9:06:30:

Having a sqlite database where a column contains guids stored as blobs.

In the select clause of a linq query, ToString() is applied on the Guid property of the model object. NHibernate will forward this to the SQL as

     select
        cast(Id as char) as col_2_0_ 

Unfortunately, the resulting strings won't contain the intended standard string representations of GUID, but instead the raw bytes directly interpreted as characters, which is something completely different.

[lillo42]

Hi,

I found how to fix this bug, We need change query to:

select entity0_.Id as col_0_0_ from Entity entity0_

I'm thinking to create a new function "strguid":

RegisterFunction("strguid", new SQLFunctionTemplate(NHibernateUtil.String, "?1"));

What do you think? Is it a good solution?

[fredericDelaporte]

I do not currently understand what is exactly the trouble, so even less what could be a good solution.
I think this issue first need a test case demonstrating the trouble.