Can primary key be of type string?

Question

Database design

The key field can be of type string? When trying to migrate after the update-database command, the following error occurs:
Identity column must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and constrained to be non nullable
How to fix? Let me know who you met.

Answer 1

It depends on the DB. In SQL Server you can. In your DBMS - obviously it is impossible. Add an identity field to your table schema and it will automatically populate as you add rows.