title: What are the advantages of LINQ to SQL?
body: <p>I've just started using LINQ to SQL on a mid-sized project, and would like to increase my understanding of what advantages L2S offers.</p>
  
  <p>One disadvantage I see is that it adds another layer of code, and my understanding is that it has slower performance than using stored procedures and ADO.Net.  It also seems that debugging could be a challenge, especially for more complex queries, and that these might end up being moved to a stored proc anyway.</p>
  
  <p>I've always wanted a way to write queries in a better development environment, are L2S queries the solution I've been looking for?  Or have we just created another layer on top of SQL, and now have twice as much to worry about?</p>