Entity Framework with stored procedure using defining query

Question

I wrote a defining query

 <EntitySet Name="EntityFramework" EntityType="SEOAnalysisModel.Store.EntityFramework">
     <DefiningQuery>
         SELECT Keyword, ResultHead ,Year from SeoAnalysis where Year = 2005
     </DefiningQuery>
 </EntitySet>

And entity type for custom entity

 <EntityType Name="EntityFramework">
     <Key>
         <PropertyRef Name="Year" />
     </Key>
     <Property Name="Year" Nullable="false" Type="int" />
     <Property Name="Keyword" Nullable="false" MaxLength="1000" Type="varchar" />
     <Property Name="ResultHead" Nullable="false" MaxLength="2000" Type="varchar" />
 </EntityType>

But when I call a stored procedure, it returns only 1 value of the column

// Stored procedure
public void SelectValue() {
    using (MyConnection ctx = new MyConnection()) {
        foreach (var p in ctx.EntityFramework(2005)) {
            Response.Write(p.Keyword);
        }
    }
}

And this column value is repetitive.

Now how can I get all column value?

Actually I am getting same keyword repetitive.

If I have keyword like Apple, then this keyword is repeating until loop is running.

Ladislav Mrnka · Accepted Answer · 2012-07-13 11:30:59Z

1

You have marked Year as key for the entity. Key must be unique among all records in your defining query otherwise it is not a key. If the key is not unique, EF will do exactly what you got - it will materialize only the first record into entity and use it for all other records as well. EF uses key to identify the entity - if you get two records with the same key value, EF believes that it is the same entity!

answered Jul 13, 2012 at 11:30

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework with stored procedure using defining query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related