an't write CLR type System.String with handler type Int32Handler

Posts   
 
    
hankddog
User
Posts: 52
Joined: 08-Apr-2005
# Posted on: 13-Dec-2018 22:02:29   

An exception of type 'SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException' occurred in SD.LLBLGen.Pro.ORMSupportClasses.dll but was not handled in user code

Additional information: An exception was caught during the execution of a retrieval query: Can't write CLR type System.String with handler type Int32Handler. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

Using LLBL 5.5 with npgsql 4.0.4. This is for a PostgreSQL.

When I go to npgsql 3.2.7. seems to working fine.

I assume its a them issue, not you guys?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 14-Dec-2018 06:33:14   

Indeed it seems like a bug in the npgsql provider (possible ref...).
What code triggers this error? (i.e.: the part of code that executes the sql that returns this error).

I think that maybe there is a value in the database that is null, and it can't be parsed with an Int32Handler. However we should see more of your code and your entity and table to try to reproduce it.

David Elizondo | LLBLGen Support Team