title: Linq find method
body: <p>I'm currently developing an asp.net mvc application using linq and razor as view engine.</p>
  
  <p>I have 2 doubts using the find method in linq, taking as example this database model:</p>
  
  <p><a href="https://i.stack.imgur.com/W4Q6h.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/W4Q6h.gif" alt="enter image description here"></a></p>
  
  <p>If I use the find method to find a product:</p>
  
  <pre><code>Product MyProduct = model.products.Find(id);
  </code></pre>
  
  <p>The request to the database it's like an <code>IEnumerable</code> where you select all and do the select method in local memory or you only recieve 1 record from the database?</p>
  
  <p>Also do you recieve all the data related to that product like order details?, for example if I do this:</p>
  
  <pre><code>var OrderDetails = MyProduct.OrderDetails.Where(x=&gt;x.unitprice&gt;10);
  </code></pre>
  
  <p>The select method it's in local memory (because you already have the related data there) or you make another request to the database?</p>
  
  <p>Thank you!</p>