“帮助"服务器无法生成主键列 [英] 'Help' The primary key column cannot be generated by the server

问题描述

我的创建表代码，例如:

My create table code like :

CREATE TABLE [dbo].[DeTai](
[ID] [int] IDENTITY(1,1) NOT NULL,
[MaDeTai]  AS ('DT'+right('000000'+CONVERT([varchar](10),[ID]),(6))) PERSISTED NOT NULL,
[TenDeTai] [nvarchar](255) NOT NULL,
[LinhVuc] [nvarchar](255) NOT NULL,
[Nam] [int] NOT NULL,
[MaGV] [varchar](8) NOT NULL,
)

当我使用linq到sql插入值时，此消息就会出现

When I use linq to sql to insert a values this messages come out

服务器无法生成类型为'VarChar(8)'的主键列.

我该怎么办?

推荐答案

您必须指定主键，设置标识还不够

you have to designate the primary key, setting identity is not enough

CREATE TABLE [dbo].[DeTai](
  [ID] [int] IDENTITY(1,1) NOT NULL,
  [MaDeTai]  AS ('DT'+right('000000'+CONVERT([varchar](10),[ID]),(6))) PERSISTED NOT NULL,
  [TenDeTai] [nvarchar](255) NOT NULL,
  [LinhVuc] [nvarchar](255) NOT NULL,
  [Nam] [int] NOT NULL,
  [MaGV] [varchar](8) NOT NULL,

  constraint PK_DeTail_ID primary key (ID)
)

这篇关于“帮助"服务器无法生成主键列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！