sql-server - 错误 6013：表/视图“_c.dbo.UrO”没有定义主键，无法推断出有效的主键

Question

此表/视图已被排除。要使用实体，您需要查看架构、添加正确的键并取消注释。

这是我的看法：

WITH temptable (code, DataItem, description) AS 
(
    SELECT        
        code, 
        CAST(LEFT(description, CHARINDEX(CHAR(10), description + CHAR(10)) - 1) AS nvarchar(50)) AS Expr1, 
        CAST(STUFF(description, 1, CHARINDEX(CHAR(10), description + CHAR(10)), '') AS nvarchar(50)) AS Expr2
    FROM            
        dbo.book
    WHERE        
        (idbook = 1)

    UNION ALL

    SELECT        
        code, 
        CAST(LEFT(description, CHARINDEX(CHAR(10), description + CHAR(10)) - 1) AS nvarchar(50)) AS Expr1, 
        CAST(STUFF(description, 1, CHARINDEX(CHAR(10), description + CHAR(10)), '') AS nvarchar(50)) AS Expr2
    FROM            
        temptable AS temptable_2
    WHERE        
        (description > '')), 
testno AS
(
     SELECT code, DataItem
     FROM temptable AS temptable_1
)
SELECT TOP (100) PERCENT 
    REPLACE(testno_1.DataItem, '  ', ' ') AS predmet, 
    po.code, year, info
FROM            
    testno AS testno_1 
LEFT OUTER JOIN
    dbo.book AS book_1 ON testno_1.code = book_1.code 
LEFT OUTER JOIN
    dbo.Getbook AS po ON testno_1.code = po.code
ORDER BY 
    po.code

这个问题在我的model.edmx，我需要视图来生成报告，但是当我尝试更新模型并将实体放入其中时，它向我显示了一个错误，我在顶部的标题中提到了该错误。

我与 dbo 的连接很好，一切都很好，所以唯一的问题是视图的主键。我知道无法查看主键，但我认为始终存在解决方案。

标签： sql-servermodel-view-controller