Blog - Single Post

Adding Primary key to view SQL Server 2008

  • Thursday, March 15, 2012
  • by hbopuri

SELECT isnull(server.[dbo].[table].[ProductId],-1) AS ProductID

This will create the Primarykey to the view. why do you need primary key? one of the reason is, view with no primary key from any fields selected will not be added to Entity Model. with the able line in your view, you can add view to the Entity Model.