Automatic Generation of SQL Server Stored Procedures

In. NET development, the SQL Server Stored Procedure is automatically generated:

For example, add/delete/update/getsinglerow

My recommended method:

Advanced T-SQL: automate the generation of stored procedures for your database
Http://msdn.microsoft.com/msdnmag/issues/03/04/StoredProcedures/default.aspx

Spgen-stored procedure Generator
Http://www.codeproject.com/cs/database/spgen.asp

Automatic Call of stored procedures:

Http://www.codeproject.com/dotnet/spinvoke.asp
Http://codeproject.com/useritems/SPGenerator.asp
Http://www.codeproject.com/cs/database/dbhelper.asp

Automatic data layer generation:

Suggested data layer generators
Http://asp.net/Forums/ShowPost.aspx? Tabindex = 1 & postid = 35928

Tools for automatic generation of data layers:

Llblgen pro, the N-tier generator and O/R mapper
Http://www.llblgen.com
Http://www.gavinjoyce.com
Http://www.sharppower.com
Http://www.alachisoft.com
Http://www.dnzone.com/showDetail.asp? Typeid = 23 & newsid = 545.

SQL stored procedure wrapper & Typed Dataset Generator for. net
Http://www.thecodeproject.com/cs/database/dbhelper.asp

Auto-Generating Wrapper Classes for stored procedures, Part 2: The internals of the autosproc Tool
Http://msdn.microsoft.com/data/default.aspx? Pull =/library/en-US/dndotnet/html/autointe2.asp # autointe2_topic2
Http://msdn.microsoft.com/data/default.aspx? Pull =/library/en-US/dndotnet/html/autousa2.asp

Http://www.dotnetutilities.com
Http://www.sharppower.com

Http://www.yellow-bridge.com
Http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx

Related keywords: Stored Procedure proxy generator, DOTNET framework Stored Procedure proxy generator SQL Server database C # Visual Basic wrapper Assembly Reflection emit,

Http://dotnetjunkies.com/WebLog/seichert/archive/2003/12/17/4594.aspx