UserId in AspNet WebApi

Question

Hi friends. I have successfully created AspNet Web Api. I run the project everything is ok but i am confusewhy user Id is not generated serially i.e 1234....... and also I am adding new user in database it is successfully added but not in last position in table.some time it add in lastsometime it is in middle why is this happen? please let me how to fixed this problem.

Bikesh Srivastava · Answer

Hi Make particular column is identity in sql table....

Midhun T P · Answer

Hi you have to make user id column in table as identity set datatype as int or bigint and make auto increment true.

Nitin Sontakke · Answer

Wouldn't it help if you could show table definition few rows probably. Without that how we can guess if it is a numeric column varchar column? If you have created primary key or not etc.