I have been doing some easy project for my friend in C#. I was working with mdf database (default database in Visual Studio). When I wanted to add a new table, I was unable to do it and it take me a few hours to find on the internet that I have to use some other datatype than 'text' for primary key in order to create a table. I was shocked since I never heard that you have to watch out which datatype you choose for your primary key.
Is this thing normal or I should consider it as a bug?