I have a simple entity whose PK is a Sequential Guid. The Database creates the PK.

When I save a new'd entity and ask the adapter to refetchAfterSave the SQL it generates is "Select blah from blah where PK is null" so of course does not refetch.

How can I get the entity I just new'd and saved when the PK is a DB generated Sequential Guid?

Ian

• What DB are you using?
• In case you are using SQLServer are you setting the compatibility level in your config file?
• Is such field marked as "IsIdentity" in LLBLGen Designer.

SQL 2005, compatibility level is what ever is default.

Field is as shown in attached screen grab.

Can you show us the code you are using to create and save the entity ?

Matt

Use as default on the field: NEWSEQUENTIALID(), which is a new feature introduced in sqlserver 2005. See also the documentation about NEWSEQUENTIALID()