Like this:

I have created table named "SqlCompact", with two fields Id and Name, where Id is not nullable and identity is set to true: