Question: I just started using Linq to SQL, and it just occurred to me that I don't really need any sprocs in the database since i can do all the data access through Linq to SQL. 

Is there any reason to write sprocs with Linq to SQL?

Thank you.

Answer: 
Stored procedures are very important. LinkToSQL requires direct access to insert, update, delete and select data in the tables. This means that if your site or application isn't correctly checking user input your database is open to a database injection attack.

When using stored procedures this isn't an issue as the user which logs into the database doesn't have direct table access. Access is granted to the stored procedure which gives the UI access to the tables, but only in the context of the stored procedures.
I fear you've just walked on a religous mine!

Stored procedures or not is a very hotly debated subject, and often (in my opinion) boils down to a fight between DB/SQL specialists on one side and 'vanilla' developers on the other. Each side trying to get as much of the duvet as they can.

Check out this link, [Stored procedures are bad, m'kay?](http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx) and the ensuing LOOOOONG debate.