title: Linq : problem with primary key
body: <p>I get the following error message </p>
  
  <blockquote>
    <p>The table/view 'TABLE1' does not have
    a primary key defined and no valid
    primary key could be inferred. This
    table/view has been excluded. To use
    the entity you will need to review
    your schema, add the correct keys and
    uncomment it</p>
  </blockquote>
  
  <p>when I try to add a view to an Entity Data Model. For testing, I have created a very simple view and I still get the error. below is the view definition</p>
  
  <pre><code>SELECT 
     DISTINCT TOP (100) PERCENT 
     MIN(id) AS Expr4, MIN(EmpNo) AS Expr1, 
     MIN(Name) AS Expr2, MIN(Category) AS Expr3
  FROM  dbo.MYView1
  GROUP BY id
  </code></pre>
  
  <p>does any one know of a simple work around.</p>
  
  <p>I have looked at this thread <a href="https://stackoverflow.com/questions/745341/can-ms-sql-views-have-primary-and-foriegn-keys">Can SQL Server views have primary and foreign keys?</a> but in my scenario, what is recommended is not applicable. </p>
  
  <p>If I could only have the view added to the Model.</p>