Load Related Entities With EF 5 Context.Database.SqlQuery

Question

I have this SP,

ALTER PROCEDURE [dbo].[GetPageByID]
(
    @ID INT
)
AS

    SELECT  P.*
            ,A.*
    FROM    Page P
            LEFT OUTER JOIN [dbo].[Application] A ON P.ApplicationVersion = A.[Version]
    WHERE   P.ID = @ID;

and I am using this code to load into objects,

        return context.Database.SqlQuery<Page>(@"EXEC GetPageByID {0}", new object[] { id }).FirstOrDefault();

This only loads properties of Page but not loading Page.Application property. Any way to tell EF to do this.

Ladislav Mrnka · Accepted Answer · 2013-02-10 18:54:05Z

2

No. SqlQuery is able to load only the main entity you are asking for - in your case the Page. If you want to load children as well you cannot use SqlQuery. EF5 with EDMX provides mapping for stored procedures with multiple result sets (that means you will need stored procedure with two queries - one for pages and second for applications). It is not supported with code first yet.

answered Feb 10, 2013 at 18:54

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

Collectives™ on Stack Overflow

Load Related Entities With EF 5 Context.Database.SqlQuery

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