Hello Sir
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 stored procedure it gives me only 1 value of the column
public void SelectValue()
{
using (MyConnection ctx = new MyConnection())
{
foreach (var p in ctx.EntityFramework(2005))
{
Response.Write(p.Keyword);
}
}
}
And this column value is repetative.
Now how can i get all column value?