title: Performance comparison Sql query and Linq data query
body: <p>I have two opinion about manipulating data with c# programming language environment.</p>
  
  <ol>
  <li>(<code>select * from where ...</code>) query with sql and get data.</li>
  <li>(<code>select * from</code>) get all data and use Linq query on object list.</li>
  </ol>
  
  <p>What is the performance difference about these opinions for big size or avarage size data. Can I use both of them?</p>