title: Using a view with no primary key with Entity
body: <p>I just started on a project converting an application from raw ADO.NET and embedded SQL to Entity. I ran in to a problem with one of the views used by the application. The view has no primary key and no column (or combination of columns) that uniquely identifies a row. Here is the select the view is created with:</p>
  
  <pre><code>SELECT
      filingmonth,
      CEIL(filingmonth / 3),
      licnum,
      filingyear,
      DECODE(GROUPING(insurername), '1', '- All Insured -', insurername),
      insurername,
      policylinecode,
      linedescription,
      SUM(NVL(grosspremium, 0)),
      SUM(DECODE(taxexempt, 1, grosspremium, 0)),
      TRUNC(
        CASE
          WHEN
            (
              b.rsn IS NOT NULL
              OR A.zeroreport = 1
            )
            AND b.datereceived IS NULL
              THEN A.datereceived
          ELSE b.datereceived
        END),
      SUM(aip.iscompanyadmitted(b.naiccocode, b.naicalienid)),
      A.insuredid
    FROM
      aip.slbtransinsured A
    LEFT OUTER JOIN aip.slbtransinsurer b
    ON
      A.insuredid = b.insuredid
    LEFT OUTER JOIN aip.slblinecodes C
    ON
      b.policylinecode = C.linecode
    WHERE
      A.submitted = 1
    AND A.entryincomplete = 0
    GROUP BY
      licnum,
      filingmonth,
      filingyear,
      TRUNC(
        CASE
          WHEN
            (
              b.rsn IS NOT NULL
              OR A.zeroreport = 1
            )
            AND b.datereceived IS NULL
              THEN A.datereceived
          ELSE b.datereceived
        END),
      ROLLUP(insurername, aip.iscompanyadmitted(b.naiccocode, b.naicalienid),
      policylinecode, linedescription), A.insuredid;
  </code></pre>
  
  <p>And here is some sample data showing that there are some rows that are completely duplicated (rows 3 and 4):</p>
  
  <pre><code>FILINGMONTH CEIL(FILINGMONTH/3) LICNUM FILINGYEAR DECODE(GROUPING(INSURERNAME),'1','-ALLINSURED-',INSURERNAME)                                         INSURERNAME                                                                                          POLICYLINECODE LINEDESCRIPTION                                                                                                                                                                                          SUM(NVL(GROSSPREMIUM,0)) SUM(DECODE(TAXEXEMPT,1,GROSSPREMIUM,0)) TRUNC(CASEWHEN(B.RSNISNOTNULLORA.ZEROREPORT=1)ANDB.DATERECEIVEDISNULLTHENA.DATERECEIVEDELSEB.DATERECEIVEDEND) SUM(AIP.ISCOMPANYADMITTED(B.NAICCOCODE,B.NAICALIENID)) INSUREDID
  
        6                   2   8150       2007 SAVERS PROPERTY AND CASUALTY INSURANCE CO                                                            SAVERS PROPERTY AND CASUALTY INSURANCE CO                                                            17             OTHER LIABILITY                                                                                                                                                                                                            721.25                                       0 18-JUL-07                                                                                                                                                          0        81 
        6                   2   8150       2007 SAVERS PROPERTY AND CASUALTY INSURANCE CO                                                            SAVERS PROPERTY AND CASUALTY INSURANCE CO                                                            17                                                                                                                                                                                                                                        721.25                                       0 18-JUL-07                                                                                                                                                          0        81 
        6                   2   8150       2007 SAVERS PROPERTY AND CASUALTY INSURANCE CO                                                            SAVERS PROPERTY AND CASUALTY INSURANCE CO                                                                                                                                                                                                                                                                                                      721.25                                       0 18-JUL-07                                                                                                                                                          0        81 
        6                   2   8150       2007 SAVERS PROPERTY AND CASUALTY INSURANCE CO                                                            SAVERS PROPERTY AND CASUALTY INSURANCE CO                                                                                                                                                                                                                                                                                                      721.25                                       0 18-JUL-07                                                                                                                                                          0        81 
  </code></pre>
  
  <p>insuredid is the pk for the aip.slbtransinsured table, rsn is the pk for aip.slbtransinsurer and aip.slblinecodes.</p>
  
  <p>Is it at all possible to add a view to the Entity model without a unique identifier? Or is there an easy way to add a unique row identifier to the view? The view is only read from, never written to.</p>