Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects.

Stored procedures also make it much easier to deal with edge cases and even add auditing or change-locking behavior. A stored procedure can handle many tasks that trouble ad-hoc queries.