title: Why do I need Stored Procedures when I have LINQ to SQL
body: <p>My understanding of Linq to Sql is it will take my Linq statement and convert it into an equivalent SQL statement.</p>
  
  <p>So</p>
  
  <pre><code>var products = from p in db.Products
                 where p.Category.CategoryName == "Beverages"
                 select p
  </code></pre>
  
  <p>Just turns into </p>
  
  <pre><code>Select * from Products where CategoryName = 'Beverages'
  </code></pre>
  
  <p>If that's the case, I don't see how stored procedures are useful anymore.</p>