Entity framework 6 IQueryable does not update with separate calls











up vote
1
down vote

favorite












I have an unusual problem where by if I make separate calls to an IQueryable the initial call that creates the IQueryable will generate SQL specific to the first call. This can be seen when debugging and observing the internal query.



When I make inline calls such as:



IQueryable<TableEntity> tEnt = dbCtx.table.AsNoTracking().Include(t=> t.someRefData).Where(t => t.Id >= 10);


this produces the correct internal SQL query.



However If I dynamically make the query with separate distinct calls such as:



IQueryable<TableEntity> tEnt = dbCtx.table.AsNoTracking();

tEnt.Include(t=> t.someRefData);

tEnt.Where(t => t.Id >= 10);


The internal SQL query does not update beyond the declaration of tEnt to reflect these preceeding calls.



Have I total mis-understood how IQueryable works?






linq entity-framework-6 iqueryable







share|improve this question


















  • 3




    Include and Where return new IQueryable objects, you are discarding them.
    – DavidG
    2 days ago








  • 1




    Oh im so having a derp moment ofcourse they do. The calls dont apply to the calling object only create based on what was refered to it.
    – Gelion
    2 days ago










  • Btw. a IQueryable is a kind of concatenation of commands. Is used similar to IEnumerable, but the concated commands are not called until the IQueryable is converted into an object (.singe(); .first(); singleOrDefault(); .firstOrDefault()), into an array or into an IEnumerable (e.g. .ToList() ). befor that conversation it is just a command. Also: you have to make the call before you close your container, or you will get an exception, if you try to run your concatinated commands on a closed connection
    – Horitsu
    2 days ago















up vote
1
down vote

favorite












I have an unusual problem where by if I make separate calls to an IQueryable the initial call that creates the IQueryable will generate SQL specific to the first call. This can be seen when debugging and observing the internal query.



When I make inline calls such as:



IQueryable<TableEntity> tEnt = dbCtx.table.AsNoTracking().Include(t=> t.someRefData).Where(t => t.Id >= 10);


this produces the correct internal SQL query.



However If I dynamically make the query with separate distinct calls such as:



IQueryable<TableEntity> tEnt = dbCtx.table.AsNoTracking();

tEnt.Include(t=> t.someRefData);

tEnt.Where(t => t.Id >= 10);


The internal SQL query does not update beyond the declaration of tEnt to reflect these preceeding calls.



Have I total mis-understood how IQueryable works?






linq entity-framework-6 iqueryable







share|improve this question


















  • 3




    Include and Where return new IQueryable objects, you are discarding them.
    – DavidG
    2 days ago








  • 1




    Oh im so having a derp moment ofcourse they do. The calls dont apply to the calling object only create based on what was refered to it.
    – Gelion
    2 days ago










  • Btw. a IQueryable is a kind of concatenation of commands. Is used similar to IEnumerable, but the concated commands are not called until the IQueryable is converted into an object (.singe(); .first(); singleOrDefault(); .firstOrDefault()), into an array or into an IEnumerable (e.g. .ToList() ). befor that conversation it is just a command. Also: you have to make the call before you close your container, or you will get an exception, if you try to run your concatinated commands on a closed connection
    – Horitsu
    2 days ago













up vote
1
down vote

favorite









up vote
1
down vote

favorite











I have an unusual problem where by if I make separate calls to an IQueryable the initial call that creates the IQueryable will generate SQL specific to the first call. This can be seen when debugging and observing the internal query.



When I make inline calls such as:



IQueryable<TableEntity> tEnt = dbCtx.table.AsNoTracking().Include(t=> t.someRefData).Where(t => t.Id >= 10);


this produces the correct internal SQL query.



However If I dynamically make the query with separate distinct calls such as:



IQueryable<TableEntity> tEnt = dbCtx.table.AsNoTracking();

tEnt.Include(t=> t.someRefData);

tEnt.Where(t => t.Id >= 10);


The internal SQL query does not update beyond the declaration of tEnt to reflect these preceeding calls.



Have I total mis-understood how IQueryable works?






linq entity-framework-6 iqueryable







share|improve this question













I have an unusual problem where by if I make separate calls to an IQueryable the initial call that creates the IQueryable will generate SQL specific to the first call. This can be seen when debugging and observing the internal query.



When I make inline calls such as:



IQueryable<TableEntity> tEnt = dbCtx.table.AsNoTracking().Include(t=> t.someRefData).Where(t => t.Id >= 10);


this produces the correct internal SQL query.



However If I dynamically make the query with separate distinct calls such as:



IQueryable<TableEntity> tEnt = dbCtx.table.AsNoTracking();

tEnt.Include(t=> t.someRefData);

tEnt.Where(t => t.Id >= 10);


The internal SQL query does not update beyond the declaration of tEnt to reflect these preceeding calls.



Have I total mis-understood how IQueryable works?






linq entity-framework-6 iqueryable




linq entity-framework-6 iqueryable






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 2 days ago









Gelion

152313




152313








  • 3




    Include and Where return new IQueryable objects, you are discarding them.
    – DavidG
    2 days ago








  • 1




    Oh im so having a derp moment ofcourse they do. The calls dont apply to the calling object only create based on what was refered to it.
    – Gelion
    2 days ago










  • Btw. a IQueryable is a kind of concatenation of commands. Is used similar to IEnumerable, but the concated commands are not called until the IQueryable is converted into an object (.singe(); .first(); singleOrDefault(); .firstOrDefault()), into an array or into an IEnumerable (e.g. .ToList() ). befor that conversation it is just a command. Also: you have to make the call before you close your container, or you will get an exception, if you try to run your concatinated commands on a closed connection
    – Horitsu
    2 days ago














  • 3




    Include and Where return new IQueryable objects, you are discarding them.
    – DavidG
    2 days ago








  • 1




    Oh im so having a derp moment ofcourse they do. The calls dont apply to the calling object only create based on what was refered to it.
    – Gelion
    2 days ago










  • Btw. a IQueryable is a kind of concatenation of commands. Is used similar to IEnumerable, but the concated commands are not called until the IQueryable is converted into an object (.singe(); .first(); singleOrDefault(); .firstOrDefault()), into an array or into an IEnumerable (e.g. .ToList() ). befor that conversation it is just a command. Also: you have to make the call before you close your container, or you will get an exception, if you try to run your concatinated commands on a closed connection
    – Horitsu
    2 days ago








3




3




Include and Where return new IQueryable objects, you are discarding them.
– DavidG
2 days ago






Include and Where return new IQueryable objects, you are discarding them.
– DavidG
2 days ago






1




1




Oh im so having a derp moment ofcourse they do. The calls dont apply to the calling object only create based on what was refered to it.
– Gelion
2 days ago




Oh im so having a derp moment ofcourse they do. The calls dont apply to the calling object only create based on what was refered to it.
– Gelion
2 days ago












Btw. a IQueryable is a kind of concatenation of commands. Is used similar to IEnumerable, but the concated commands are not called until the IQueryable is converted into an object (.singe(); .first(); singleOrDefault(); .firstOrDefault()), into an array or into an IEnumerable (e.g. .ToList() ). befor that conversation it is just a command. Also: you have to make the call before you close your container, or you will get an exception, if you try to run your concatinated commands on a closed connection
– Horitsu
2 days ago




Btw. a IQueryable is a kind of concatenation of commands. Is used similar to IEnumerable, but the concated commands are not called until the IQueryable is converted into an object (.singe(); .first(); singleOrDefault(); .firstOrDefault()), into an array or into an IEnumerable (e.g. .ToList() ). befor that conversation it is just a command. Also: you have to make the call before you close your container, or you will get an exception, if you try to run your concatinated commands on a closed connection
– Horitsu
2 days ago












1 Answer
1






active

oldest

votes

















up vote
1
down vote



accepted










tEnt = tEnt.Include(t=> t.someRefData);





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',
    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%2f53373692%2fentity-framework-6-iqueryable-does-not-update-with-separate-calls%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    1
    down vote



    accepted










    tEnt = tEnt.Include(t=> t.someRefData);





    share|improve this answer



























      up vote
      1
      down vote



      accepted










      tEnt = tEnt.Include(t=> t.someRefData);





      share|improve this answer

























        up vote
        1
        down vote



        accepted







        up vote
        1
        down vote



        accepted






        tEnt = tEnt.Include(t=> t.someRefData);





        share|improve this answer














        tEnt = tEnt.Include(t=> t.someRefData);






        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited 2 days ago









        Logan

        2,08932856




        2,08932856










        answered 2 days ago









        Horitsu

        206210




        206210






























             

            draft saved


            draft discarded



















































             


            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53373692%2fentity-framework-6-iqueryable-does-not-update-with-separate-calls%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

            MongoDB - Not Authorized To Execute Command

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I have successfully enabled authorization on MongoDB and I have created an account on the admin database and then I created an account for my database called test. The following connection string to connect to my test database works successfully: mongo --host 192.168.17.52 --port 27017 -u user1 -p password --authenticationDatabase test Only problem I have now is, I cannot execute commands such as: show dbs. I get the following error when I try to do so: "errmsg" : "not authorized on admin to execute command { listDatabases: 1.0, lsid: { id: UUID("a1d5bc0d-bc58-485e-b232-270758a89455") }, $db: "admin...
            Read more

            How to fix TextFormField cause rebuild widget in Flutter

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I've got the same issue at #9280. I tried all solutions from that topic with/without GlobalKey for Scaffold and Form but the problem wasn't fixed. I tried to build a authentication form with login and signup. But the keyboard doesn't show when I tap the TextFormField at the first time. Then I try to input some letter from physical keyboard, the widget is rebuilt. Like this: login screen Nothing to be log when I run flutter run --verbose, so I logged manually. Every tapping on field, the widget called dispose -> init -> build. [√] Flutter (Channel beta, v1.0.0, on Microsoft Windows [Version 10.0.17763.195], ...
            Read more

            in spring boot 2.1 many test slices are not allowed anymore due to multiple @BootstrapWith

            Image
            1 I tried to upgrade a yummy sandwich made of two test slices (@JsonTest and @JdbcTest in my case, crunchy test code in between) adding spring boot 2.1 flavour to it. But it seems it was not much of a success. I cannot annotate my tests with many @...Test since they are now each bringing their own XxxTestContextBootstrapper. It used to work when they all used same SpringBootTestContextBootstrapper. @RunWith(SpringRunner.class) @JdbcTest @JsonTest public class Test { @Test public void test() { System.out.printn("Hello, World !"); } } The error I get from BootstrapUtils is illegalStateException : Configuration error: found multiple declarations of @BootstrapWith for test class I understand I might be doing something wrong here but is there an easy way I could load both Json and Jdbc contex...
            Read more