sql server - Retrieving Data from Stored Procedure in MVC -

i have following 2 model classes

public partial class items {     public items() {         this.items_ratings = new hashset<items_ratings>();     }      public int itemid { get; set; }     public string itemname { get; set; }     public virtual icollection<items_ratings> items_ratings { get; set; } }  public partial class items_ratings {     public int itemsid { get; set; }     public byte itemsrating { get; set; }     public string comments { get; set; }     public virtual items items { get; set; }  } 

i've created stored procedure review average rating

create procedure dbo.get_item_averagerating @itemid int  begin    select avg(overallrating) overallrating items_ratings itemid = @itemid group itemid end go 

in model class, have added

public virtual icollection<get_item_averagerating_result> get_item_averagerating { get; set; } 

in controller calls, tried adding

return view(db.items.include(c => c.get_item_averagerating).tolist()); 

however, i'm not getting value. throwing error.

you need add stored procedure edmx model

here how it

1- open edmx file

2- next right click anywhere on edmx designer , choose add > function import.

3- bring wizard adding function. choose procedure want add , choose return type .

4- can call stored procedure clr method dbcontext.