title: Linq, is select().SingleorDefault() a bad idea?
body: <pre><code> var queueitem = context.CrawlerQueues.
                   Select(cq =&gt; new{cq.Guid,cq.Result}).
                   SingleOrDefault(cq =&gt; cq.Guid == guid);
  </code></pre>
  
  <p>Is above a bad idea, will it first select all database rows and then find the one or will it be smart and see the context its used within and only fetch the one row.</p>
  
  <p>Reason for doing this is i want to return only the Guid and the Result coloums. </p>
  
  <pre><code>return Newtonsoft.Json.JsonConvert.SerializeObject(queueitem, Formatting.Indented);
  </code></pre>
  
  <p>How would i find the answer to this without having to monitor network flow or the requests made to the database?</p>