Loading

UserId in AspNet WebApi

sameer shaikh

10y824.NET

Hi friends.

I have successfully created AspNet Web Api. I run the project, everything is ok, but i am confuse,why user Id is not generated serially i.e 1,2,3,4....... 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 last,sometime it is in middle, why is this happen?

please let me how to fixed this problem.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Hi,
Make particular column is identity in sql table....
Midhun Tp10y ago
Hi, you have to make user id column in table as identity, set datatype as int or bigint and make auto increment true.
Nitin Sontakke10y ago
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.