Entity Framework - Include 3 sublevels of properties












1














I'm using EF6 Code-First.
I have four-leveled entities with the following hierarchy: 



Express(top level) 

    -> Constant(1st sublevel) 

    -> Event(also 1st sublevel) 

         -> Parameter(2nd sublevel) 

              -> Value(3rd sublevel)


I can obtain 2 sublevels via



db.Expresses.Include(ex=>ex.Constants).Include(ex=>ex.Events.Select(ev=>ev.Parameters));


But how can I include third sublevel (Value) in that query?






c# entity-framework entity-framework-6







share|improve this question
























  • Possible duplicate of EF LINQ include multiple and nested entities
    – CodeNotFound
    Nov 20 at 8:56
















1














I'm using EF6 Code-First.
I have four-leveled entities with the following hierarchy: 



Express(top level) 

    -> Constant(1st sublevel) 

    -> Event(also 1st sublevel) 

         -> Parameter(2nd sublevel) 

              -> Value(3rd sublevel)


I can obtain 2 sublevels via



db.Expresses.Include(ex=>ex.Constants).Include(ex=>ex.Events.Select(ev=>ev.Parameters));


But how can I include third sublevel (Value) in that query?






c# entity-framework entity-framework-6







share|improve this question
























  • Possible duplicate of EF LINQ include multiple and nested entities
    – CodeNotFound
    Nov 20 at 8:56














1












1








1







I'm using EF6 Code-First.
I have four-leveled entities with the following hierarchy: 



Express(top level) 

    -> Constant(1st sublevel) 

    -> Event(also 1st sublevel) 

         -> Parameter(2nd sublevel) 

              -> Value(3rd sublevel)


I can obtain 2 sublevels via



db.Expresses.Include(ex=>ex.Constants).Include(ex=>ex.Events.Select(ev=>ev.Parameters));


But how can I include third sublevel (Value) in that query?






c# entity-framework entity-framework-6







share|improve this question















I'm using EF6 Code-First.
I have four-leveled entities with the following hierarchy: 



Express(top level) 

    -> Constant(1st sublevel) 

    -> Event(also 1st sublevel) 

         -> Parameter(2nd sublevel) 

              -> Value(3rd sublevel)


I can obtain 2 sublevels via



db.Expresses.Include(ex=>ex.Constants).Include(ex=>ex.Events.Select(ev=>ev.Parameters));


But how can I include third sublevel (Value) in that query?






c# entity-framework entity-framework-6




c# entity-framework entity-framework-6






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 20 at 8:52









CodeNotFound

12.6k53246




12.6k53246










asked Nov 20 at 8:39









bairog

95931231




95931231












  • Possible duplicate of EF LINQ include multiple and nested entities
    – CodeNotFound
    Nov 20 at 8:56


















  • Possible duplicate of EF LINQ include multiple and nested entities
    – CodeNotFound
    Nov 20 at 8:56
















Possible duplicate of EF LINQ include multiple and nested entities
– CodeNotFound
Nov 20 at 8:56




Possible duplicate of EF LINQ include multiple and nested entities
– CodeNotFound
Nov 20 at 8:56












2 Answers
2






active

oldest

votes


















1














db.Expresses.Include(ex => ex.Constants)

            .Include(ex => ex.Events.Select(ev => ev.Parameters.Select(par => par.Value)));


Please ensure using System.Data.Entity namespace to get the overrides of Include method.
See this link for more examples.






share|improve this answer























  • Oh, that was so easy :) Thx.
    – bairog
    Nov 20 at 8:54



















0














An alternative is to use strings



db.Expresses.Include("Constants")

            .Include("Events.Parameters.Values")





share|improve this answer





















    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53389089%2fentity-framework-include-3-sublevels-of-properties%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    1














    db.Expresses.Include(ex => ex.Constants)
    
            .Include(ex => ex.Events.Select(ev => ev.Parameters.Select(par => par.Value)));


    Please ensure using System.Data.Entity namespace to get the overrides of Include method.
    See this link for more examples.






    share|improve this answer























    • Oh, that was so easy :) Thx.
      – bairog
      Nov 20 at 8:54
















    1














    db.Expresses.Include(ex => ex.Constants)
    
            .Include(ex => ex.Events.Select(ev => ev.Parameters.Select(par => par.Value)));


    Please ensure using System.Data.Entity namespace to get the overrides of Include method.
    See this link for more examples.






    share|improve this answer























    • Oh, that was so easy :) Thx.
      – bairog
      Nov 20 at 8:54














    1












    1








    1






    db.Expresses.Include(ex => ex.Constants)
    
            .Include(ex => ex.Events.Select(ev => ev.Parameters.Select(par => par.Value)));


    Please ensure using System.Data.Entity namespace to get the overrides of Include method.
    See this link for more examples.






    share|improve this answer














    db.Expresses.Include(ex => ex.Constants)
    
            .Include(ex => ex.Events.Select(ev => ev.Parameters.Select(par => par.Value)));


    Please ensure using System.Data.Entity namespace to get the overrides of Include method.
    See this link for more examples.







    share|improve this answer














    share|improve this answer



    share|improve this answer








    edited Nov 20 at 8:54









    CodeNotFound

    12.6k53246




    12.6k53246










    answered Nov 20 at 8:48









    Ayberk

    484210




    484210












    • Oh, that was so easy :) Thx.
      – bairog
      Nov 20 at 8:54


















    • Oh, that was so easy :) Thx.
      – bairog
      Nov 20 at 8:54
















    Oh, that was so easy :) Thx.
    – bairog
    Nov 20 at 8:54




    Oh, that was so easy :) Thx.
    – bairog
    Nov 20 at 8:54













    0














    An alternative is to use strings



    db.Expresses.Include("Constants")
    
            .Include("Events.Parameters.Values")





    share|improve this answer


























      0














      An alternative is to use strings



      db.Expresses.Include("Constants")
      
            .Include("Events.Parameters.Values")





      share|improve this answer
























        0












        0








        0






        An alternative is to use strings



        db.Expresses.Include("Constants")
        
            .Include("Events.Parameters.Values")





        share|improve this answer












        An alternative is to use strings



        db.Expresses.Include("Constants")
        
            .Include("Events.Parameters.Values")






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 24 at 15:01









        Leo

        4,89462438




        4,89462438






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53389089%2fentity-framework-include-3-sublevels-of-properties%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            Ottavio Pratesi

            Image
            .mw-parser-output .avviso .mbox-text-div>div,.mw-parser-output .avviso .mbox-text-full-div>div{font-size:90%}.mw-parser-output .avviso .mbox-image div{width:52px}.mw-parser-output .avviso .mbox-text-full-div .hide-when-compact{display:block} Questa voce sull'argomento ciclisti italiani è solo un abbozzo . Contribuisci a migliorarla secondo le convenzioni di Wikipedia. Ottavio Pratesi Nazionalità   Italia Ciclismo Specialità Strada Ritirato 1927 Carriera Squadre di club 1910-1911 Individuale 1912   Alcyon-Dunlop 1913 Globo-Dunlop 1914   Alcyon-Dunlop 1915-1922 Individuale 1923 Lygie 1924 Ostende 1925 Individuale   Modifica dati su Wikidata  · Manuale Ottavio Pratesi (Rosignano Marittimo, 1º gennaio 1889 – Livorno, 3 novembre 1977) è stato un ciclista su strada italiano, professionista tra il 1910 ed il 1925, era soprannominato il "Falco di ...
            Read more

            Tricia Helfer

            Image
            Tricia Helfer Tricia Helfer al Comic-Con 2015 Altezza 179 [1]  cm Misure 86-61-89 [1] Taglia 38 [1] (UE) - 8 [1] (US) Scarpe 40 [1] (UE) - 9 [1] (US) Occhi Azzurri [1] Capelli Biondo scuro [1] Modifica dati su Wikidata  · Manuale Tricia Helfer (Donalda, 11 aprile 1974) è una supermodella e attrice canadese, conosciuta principalmente per il suo ruolo di Numero Sei nella serie televisiva Battlestar Galactica . Indice 1 Carriera 2 Filmografia 2.1 Cinema 2.2 Televisione 2.3 Video musicali 2.4 Doppiatrice 2.4.1 Cinema 2.4.2 Televisione 2.4.3 Videogiochi 2.5 Produttrice 2.6 Agenzie 3 Doppiatrici italiane 4 Note 5 Altri progetti 6 Collegamenti esterni Carriera | Di origine inglese, tedesca, norvegese e svedese, nel 1992 Tricia vinse il concorso di "Ford Models Supermodel of the World", organizzato dall'agenzia Ford Models e fu poi assunta dall'agenzia ...
            Read more

            15 giugno

            Image
            gennaio  · febbraio  · marzo  · aprile  · maggio  · giugno 2018  · luglio  · agosto  · settembre  · ottobre  · novembre  · dicembre Ve Sa Do Lu Ma Me Gi Ve Sa Do Lu Ma Me Gi Ve Sa Do Lu Ma Me Gi Ve Sa Do Lu Ma Me Gi Ve Sa ← 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 → Il 15 giugno è il 166º giorno del calendario gregoriano (il 167º negli anni bisestili). Mancano 199 giorni alla fine dell'anno. Indice 1 Eventi 2 Nati 3 Morti 4 Feste e ricorrenze 4.1 Civili 4.2 Religiose 5 Altri progetti Eventi | 763 a.C. – Gli Assiri registrano un'eclissi solare 923 – Battaglia di Soissons: re Roberto I di Francia viene ucciso, re Carlo il Semplice viene arrestato dai sostenitori del duca Rodolfo di Borgogna 1094 – Reconquista: Valencia cade nelle mani di El Cid 1215 – Re Giovanni d'Inghilterra appone i...
            Read more