title: How does LINQ work with Sitecore item.GetChildren()?
body: <p>Suppose, we have a line of code</p>
  
  <pre><code>item.GetChildren().Where(i =&gt; i.Name == "something");
  </code></pre>
  
  <p>where item is of type Sitecore.Data.Items.Item.</p>
  
  <p>How does it work?</p>
  
  <p>1) after .GetChildren() call a query to database gets invoked, results returned, and then .Where(i => i.Name == "something") happens on client side</p>
  
  <p>or</p>
  
  <p>2) .Where(i => i.Name == "something") gets appended to the database query and only after that the database query gets invoked and results returned?</p>
  
  <p>or both options aren't correct?</p>