A good way to access stored procedure on SQL Server 2008 from C#

Question

I am trying to access stored procedures from my ASP.NET / C# web-application.

Is there a particularly good way to do so (also a good way to pass parameters to it)?

I followed following steps and absolutely don't like the approach, as you enter the procedure as a string (un-debugable): http://www.c-sharpcorner.com/UploadFile/dclark/InsOutsinCS11302005072332AM/InsOutsinCS.aspx

Answer 1

If you were to use LinqToSQL, ScottGU has some excellent blog posts on the subject.