Error with GUID primary keys

Posts   
 
    
bot2600
User
Posts: 17
Joined: 12-Mar-2006
# Posted on: 07-Jun-2006 23:39:45   

I am running into an error when creating an entity that has a GUID as the primary key and as a foriegn key to itself.

The error I am getting is:

An exception was caught during the execution of an action query: Operand type clash: numeric is incompatible with uniqueidentifier. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

It is getting thrown right after this method

    protected override DynamicQueryEngineBase CreateDynamicQueryEngine()
    {
        DynamicQueryEngine toReturn = new DynamicQueryEngine();
        toReturn.PerCallCatalogNameOverwrites = _catalogNameOverwrites;
        toReturn.PerCallSchemaNameOverwrites = _schemaNameOverwrites;
        return (DynamicQueryEngineBase)toReturn;
    }

All the fields are populated with the proper data types. I can give code/schema information if it is helpful.

Thanks! Bob

bot2600
User
Posts: 17
Joined: 12-Mar-2006
# Posted on: 08-Jun-2006 00:50:32   

Actually I found another person that had the same problem.

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=4908&HighLight=1

so even though I changed the PKs in all the tables from int to guid, the designer does not change all the genned code. The solution was to drop all the entities from the designer and add them again, definitely a bug!

Thanks! Bob

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 08-Jun-2006 08:03:03   

This was reported before and should have been fixed: Please check the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5257

Please use the latest version of LLBLGen Pro.

Thanks.