Clarification on Lazy Loading -LINQ Query

Question

Can you clarify this please?

public static void MyMethod()
        {
          var context= new MyModel.Entities();

          //myQuery will not have result yet
           var myQuery= from a in context.MyEntity where a.id==10 select a;

          // object is populated in myqueryResults.
           var MyqueryResults= myQuery.ToList();       
        }

My Understanding of Lazy Loading is, the properties will not populated until, you need, them.

Question: There are no values coming back in myQuery, until we say .ToList(). So, Is this also a lazy loading?

usr · Accepted Answer · 2012-06-28 15:22:25Z

1

This is not lazy-loading but lazy execution. Calling ToList twice will execute SQL two times. The result is not "cached" somewhere.

Actually, not ToList is the trigger but enumeration of the sequence. That's a difference.

answered Jun 28, 2012 at 15:22

usr

172k38 gold badges251 silver badges380 bronze badges

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

Collectives™ on Stack Overflow

Clarification on Lazy Loading -LINQ Query

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