In all of my previous websites I have worked with MsSQL using the SqlCommand class to interact with the database itself. I have seen a lot of hype about "Linq to SQL". I think that I am okay with the syntax and usage.
Why should I use "Linq to SQL"? What benefits does it have over the SqlCommand approach? Does this mean that my web application is going to be doing all of the query processing? Is it not best to have the SQL server do the hard work?
Or, do you guys recommend another approach?