我有一张表格,想要向其中插入数据但不想指定UserID
。我希望这个ID能够自动生成。
CREATE TABLE [dbo].[UserMaster]
(
[UserID] INT NOT NULL ,
[UserName] VARCHAR (50) NULL,
[UserPassword] VARCHAR (50) NULL,
[UserRoles] VARCHAR (500) NULL,
[UserEmailID] VARCHAR (100) NULL,
PRIMARY KEY CLUSTERED ([UserID] ASC)
);
这里我尝试使用C#插入行:
using (LessonesDBEntities context = new LessonesDBEntities())
{
var u = new UserMaster//Make sure you have a table called UserMaster in DB
{
UserName = "test username",
UserPassword = "test password",
UserEmailID = "test email",
UserRoles = "User"
};
context.UserMaster.Add(u);
context.SaveChanges();
}
但我收到了异常:
主键约束'PK__tmp_ms_x__1788CCACDB8355D2'的违规。无法在对象'dbo.UserMaster'中插入重复键。重复键值为(0)。 已终止该语句。
IDENTITY
属性。 - Thom A