How to use a stored procedure for Entity Framework model?

Question

Hi before I use to retrieve and manipulate data directly from my DB..but this time I am using Entity Data Model.. I have all the tables in my .edmx file .... I have some queries in my DB for retrieving data but now as I am using Entity Data Model I don't know how to call that procedure in my controller as I am using MVC 3 here can any one tell me how to get the data using my stored procedure or write a Linq query similar to my stored procedure in my controller

Here is my stored procedure:

  ALTER procedure [dbo].[ProjectReports]
   (
    @ProjectID int,
    @ReleasePhaseID int
   )
   as
   begin
   select distinct projectName,ReleasePhase,
   (Select  COUNT(1) from Bugs where ProjectId=a.ProjectId and           
     ReleasePhaseID=a.ReleasePhaseID and
     bugid in (select BugID from BugHistory where [status]='New')) as Newbugs,
     (Select  COUNT(1) from Bugs where ProjectId=a.ProjectId and    
     ReleasePhaseID=a.ReleasePhaseID and
     bugid in (select BugID from BugHistory where [status]='Assigned')) as  
     Assignedbugs,
     (Select  COUNT(1) from Bugs where ProjectId=a.ProjectId and  
     ReleasePhaseID=a.ReleasePhaseID and
     bugid in (select BugID from BugHistory where [status]='Fixed')) as Fixedbugs,
      (Select  COUNT(1) from Bugs where ProjectId=a.ProjectId and
       ReleasePhaseID=a.ReleasePhaseID and
     bugid in (select BugID from BugHistory where [status]='Re-Opened')) as 
Reopenedbugs,
    (Select  COUNT(1) from Bugs where ProjectId=a.ProjectId and 
     ReleasePhaseID=a.ReleasePhaseID and
     bugid in (select BugID from BugHistory where [status]='Closed')) as Closedbugs,
     (Select  COUNT(1) from Bugs where ProjectId=a.ProjectId and  
     ReleasePhaseID=a.ReleasePhaseID and
     bugid in (select BugID from BugHistory where [status]='Deffered')) as Defferedbugs,
     (Select  COUNT(1) from Bugs where ProjectId=a.ProjectId and  
      ReleasePhaseID=a.ReleasePhaseID and
      bugid in (select BugID from BugHistory where [status]='Not a Bug')) as NotaBug
      from Bugs a
      inner join Projects p on p.ProjectId=a.ProjectId
      inner join ReleasePhase Rp on rp.ReleasePhaseID=a.ReleasePhaseID
      where a.ProjectId=@ProjectID and a.ReleasePhaseID=@ReleasePhaseID
     end

How do I do this?

Saeed Neamati · Accepted Answer · 2012-08-18 08:31:28Z

1

The easy way is:

Open your .edmx model in VS designer
Right-click and select "Update Model From Database..." (stuff like that)
Choose your SP from the given dialog and hit "Finish"

In your Controller write:

 var result = new YourEntitiesName().StoredProcedureName();

answered Aug 18, 2012 at 8:31

Saeed Neamati

35.9k42 gold badges140 silver badges192 bronze badges

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

1 Comment

Saeed Neamati Over a year ago

It works without function import. I don't know the details though.

Collectives™ on Stack Overflow

How to use a stored procedure for Entity Framework model?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related