Adding a New record to SQLCE

[Jeff]

I have a SQLCE table with a GUID for a primary key. I understand (I
think) that, when adding a new record, I don't specify the primary key
value. But how do I then retrieve the primary key value for the
just-added record? (I'm using vb.net)

Thanks for your help.

- Jeff

 

[Chris Tacke, eMVP]

No, you will have to specify the PK value. Identity would mean you don't
have to (it's basically an autonumber).