Drawbacks of using nvarchar primary key in MVC

Asked Apr 12 '19 at 08:24

Active Apr 12 '19 at 08:24

Viewed 84 times

For convienience I've changed my tables' primary keys to the nvarchar type. But now my views and controllers don't work in MVC.

If I manually add [Key] attribute to Id column which isn't a PRIMARY KEY will it work normally? How this change can hurt my application. What should I look out for?

asked Apr 12 '19 at 08:24

Pomme De Terre

Possible duplicate of [SQL primary key: integer vs varchar](https://stackoverflow.com/questions/3162202/sql-primary-key-integer-vs-varchar) – Andrei Dragotoniu Apr 12 '19 at 10:40
"convenience" is not a valid reason to change the type of the primary key. I'd go back to that. – Andrei Dragotoniu Apr 12 '19 at 10:41
if your data is big, the performance will be a problem – Hien Nguyen Apr 12 '19 at 11:43
What is a big database? – Pomme De Terre Apr 12 '19 at 13:56

Drawbacks of using nvarchar primary key in MVC

0 Answers0