CREATE TABLE Video
(
ID INT NOT NULL PRIMARY KEY IDENTITY(1,1),
VideoName VARCHAR(100) NOT NULL
)
CREATE TABLE User
(
ID INT NOT NULL PRIMARY KEY IDENTTITY(1,1),
UserName VARCHAR(100) NOT NULL
)
CREATE TABLE VideoToUser
(
ID INT NOT NULL PRIMARY KEY IDENTITY(1,1),
VideoId INT NOT NULL FOREIGN KEY REFERENCES Video(Id),
UserId INT NOT NULL FOREIGN KEY REFERENCES User(Id)
)
两个实体类
public class Video
{
public int Id;public string VideoName;
}
public class User
{
public int Id;public string UserName;
}