sqlserver 获得行号作为唯一id

最新推荐文章于 2024-08-13 11:09:22 发布

weixin_33869377

最新推荐文章于 2024-08-13 11:09:22 发布

阅读量888

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/taoshengyujiu/p/5455178.html

版权

当sqlserver创建的view没有唯一的标识字段里，entity framework codefirst配置会出现错误，因为取其行号作为唯一标识列

CREATE VIEW [SafeWatch].[MissionInvalidItemView]
AS
SELECT ROW_NUMBER() OVER(ORDER BY aci.Id ASC) AS RowNumber,
ac.AppCheckItemId,

FROM SafeWatch.AppCheck ac
INNER JOIN SafeWatch.AppCheckItem aci ON aci.Id = ac.AppCheckItemId
LEFT JOIN SafeWatch.MissionInvalidItem mii ON mii.AppCheckId = ac.Id
WHERE ac.CheckResult>1

转载于:https://www.cnblogs.com/taoshengyujiu/p/5455178.html