测试用的当前最新版本:

sql：

---CREATE TABLE Users( UserID INT IDENTITY(1,1) PRIMARY KEY, [Name] VARCHAR(50) NULL, [No] VARCHAR(50) NULL)GOINSERT INTO Users([Name],[NO]) VALUES('geovindu','001')INSERT INTO Users([Name],[NO]) VALUES('sibodu','002')select * FROM dbo.UsersCREATE TABLE Projects(	ProjectID INT IDENTITY(1,1) PRIMARY KEY,	[Name] VARCHAR(50) NULL,	UserID INT 	FOREIGN KEY REFERENCES Users(UserID)	)GOINSERT INTO Projects([Name],UserID) VALUES('中考',1)INSERT INTO Projects([Name],UserID) VALUES('高考',1)INSERT INTO Projects([Name],UserID) VALUES('小考',2)select * FROM dbo.UserDetailsCREATE TABLE UserDetails(	UserID INT	FOREIGN KEY REFERENCES Users(UserID),	Sex INT NULL,	Age INT NULL,	BirthDate DATETIME DEFAULT(GETDATE()),	Height DECIMAL(6,2) DEFAULT(0))GOINSERT INTO UserDetails(UserID,Sex,Age,BirthDate,Height) VALUES(1,1,40,'1977-02-14',172.01)INSERT INTO UserDetails(UserID,Sex,Age,BirthDate,Height) VALUES(2,1,10,'2007-12-07',122.01)CREATE TABLE Product(	ProductID INT IDENTITY(1,1) PRIMARY KEY,	[Name] VARCHAR(50) NULL,	Color VARCHAR(50) NULL)GOINSERT INTO Product([Name],Color) VALUES('电视机','黑色')INSERT INTO Product([Name],Color) VALUES('洗碗机','白色')INSERT INTO Product([Name],Color) VALUES('微波炉','白色')INSERT INTO Product([Name],Color) VALUES('笔记本','红色')INSERT INTO Product([Name],Color) VALUES('电脑','红色')INSERT INTO Product([Name],Color) VALUES('办公桌','红色')INSERT INTO Product([Name],Color) VALUES('轿车','红色')INSERT INTO Product([Name],Color) VALUES('笔','红色')INSERT INTO Product([Name],Color) VALUES('纸张','红色')CREATE TABLE ProjectProduct(  ProjectID INT   FOREIGN KEY REFERENCES Projects(ProjectID),	ProductID INT 	 FOREIGN KEY REFERENCES Product(ProductID))GOINSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(1,2)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(1,3)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(1,4)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(1,6)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(2,1)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(2,2)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(2,3)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(2,4)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(2,7)INSERT INTO ProjectProduct(ProjectID,ProductID) VALUES(2,8)CREATE TABLE Tasks(	TaskID INT IDENTITY(1,1) PRIMARY KEY,	[Name] VARCHAR(50) NULL,	ProjectID INT   FOREIGN KEY REFERENCES Projects(ProjectID)   )GOINSERT INTO Tasks([Name],ProjectID) VALUES('提醒交货',1)INSERT INTO Tasks([Name],ProjectID) VALUES('提醒验收',2)

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：Fluent NHibernate other example

关键词：Hibernate