c# - Visual Studio/Microsoft sql 关系键错误

Question

CREATE TABLE TBLUSER_INFO
(
ID INT IDENTITY(1,1)not null PRIMARY KEY,
LNAME VARCHAR(50)not null,
FNAME VARCHAR(50)not null,
MNAME VARCHAR (50)not null,
ADDRESS VARCHAR(50)not null,
AGE INT not null,
GENDER VARCHAR(10)not null,
CONTACTNO varchar(50) not null, 
BIRTHDATE datetime
);


CREATE TABLE TBLUSER_ACCOUNT
(
ID INT FOREIGN KEY REFERENCES TBLUSER_INFO(ID) ,
USERNAME VARCHAR(50)not null,
USERPASS NVARCHAR(50)not null,
SECURITYQUESTION VARCHAR(max)not null,
SECURITYANSWER VARCHAR(50)not null
);

错误是这样的

DBML1011: The Type element 'TBLUSER_ACCOUNT' contains the Association element 'TBLUSER_INFO_TBLUSER_ACCOUNT' but does not have a primary key.  No code will be generated for the association.

<小时/>

当我以可视方式运行系统时，这将是输出 my system

请帮助我完成我的项目。我很绝望

Answer 1

SQL SERVER 要求在声明任何外键之前表中有一个主键。

Here你可以明白为什么。