title: FirstorDefault() causes lazy loading or eager loading for linq to sql
body: <p>What is default behavior of FirstOrDefault() when used with Linq to SQL?</p>
  
  <p>For e.g </p>
  
  <pre><code>  int value =   (from p in context.tableX         
                  select p.Id).FirstOrDefault()      // Value will initialized here or
  
     if(value &gt; 0)                      // query will be executed here????
     {
      //do something
     }
  </code></pre>
  
  <p>Thanks</p>