This is an excellent tool and a must see for all SQL Server programmers. Its a stored procedure which automatically generates C# code for any of existing stored procedure that you have in your database. Just run this SQL Script from your Query Analyzer which will create store procedure named "tools_CS_SPROC_Builder" which can be used to generete codes in C#. After executing the script type exec tools_CS_SPROC_Builder 'yourstoredprocedurenamehere' and see the C# sharp code in the message window. Simple isn't it?

Download the source code and read more here.