title: When is data loaded into app server's memory?
body: <p>We have a DB table having a binary column. Each row stores the file content of a file. We want to avoid loading the file content (each can be 10-20Mb in size) into app server's memory unless when necessary. </p>
  
  <p>In the following queries, will the file content be loaded into app server's memory? If yes, during which function call?</p>
  
  <pre><code>// Query 1
  dataContext.DataFiles.OrderBy(w =&gt; w.atimestamp).ToList();
  
  
  // Query 2
  var filesizes = from DataFiles in dataContext.DataFiles
                  select DataFiles.FileContent.Length;
  </code></pre>