Adding Primary key to view SQL Server 2008
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.