Using Entity Framework to Call Stored Procedure using context

Question

I can't figure out what I am doing wrong I am new to this entity framework. I am just trying to call this simple stored procedure which returns one or none persons.

This is the error I get:

Cannot implicitly convert type 'System.Data.Objects.ObjectResult' to 'Model.Person'

Stored Procedure:

Create PROCEDURE [dbo].[GetPersonByID] 
@personID int

AS
BEGIN
    SELECT        PersonID, FirstName, LastName, DOB, Notes,  Reason, Diagnosis, DateEntered
    FROM            Person
    WHERE         PersonID = @personID
END

I updated my entity and see the stored procedure here. I also right clicked on my stored procedure and added a function import and tied it to the Person Entity.

Code:

private static Person GetPersonByID(int personID)
{
    try
    {
        ModelEntities context = new ModelEntities();

        return context.GetPersonByID(personID);
    }
    catch (Exception ex)
    {
        return null;
    }
}

DavidG · Accepted Answer · 2014-07-02 14:23:36Z

1

The function GetPersonByID is returning an ObjectResult type, you need to convert it to your model. Something like this:

var persons = context.GetPersonByID(personID).Select(p => new Model.Person
{
    Name = p.Name,
    Age p.Age,
    ... etc ...
});

return persons.SingleOrDefault();

answered Jul 2, 2014 at 14:23

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

3 Comments

wolfeh Over a year ago

Shouldn't it recognize that it is a person object through the Function Imports? What happens if you have the same code but return a dataset of all the persons? It seems like there is a more straight forward solution.

DavidG Over a year ago

Think of the ObjectResult return type as a collection of your objects. Your code is trying to assign that collection to an individual Model.Person.

DavidG Over a year ago

If the return type is actually ObjectResult<Person> then you may be able to simplify it to return context.GetPersonByID(personID).SingleOrDefault()

Bhasyakarulu Kottakota · Accepted Answer · 2014-07-02 14:27:10Z

0

Seems there is mismatch between the SP result set and yours entity. Try to update entity same as result set or vice versa.

** It would be greatly helpful, if you can provide entity code as well. That way we can test within my test environment.

answered Jul 2, 2014 at 14:27

Bhasyakarulu Kottakota

8331 gold badge6 silver badges10 bronze badges

1 Comment

wolfeh Over a year ago

I wish I could upload not not sure how or what to do. I updated my entity but I still have the same error.

Collectives™ on Stack Overflow

Using Entity Framework to Call Stored Procedure using context

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related