开发者

SQL Database Primary Key disappears from couple tables

SQL Database Primary Key disappears from couple tables. I don't know the core reason why this happened I'm still investigating it. In mean time maybe someone had similar problem, because nobody did remove them. So far I think it’s kind of related LINQ to Entity model it could happen but I’m not sure why.

I got the error below as the matter of fact it was working properly before

Unable to update the EntitySet 'TableName' because it has a DefiningQuery and no element exists in the element to support开发者_运维知识库 the current operation

Any suggestion will be appreciated. Thanks


SQL Server replication does not produce primary keys when creating tables. If there's a replication job that recreates these tables, that'd be the problem.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜