In .NET development, the SQL Server stored procedure is automatically generated:
If you operate on the table, add / delete / update / getsinglerow
I recommend:
Advanced T-SQL: Automate The Generation of Stored Procedures for Your DatabaseHttp: //msdn.microsoft.com/msdnmag/issues/03/4/storedProcedures/default.aspx
SPGEN - Stored Procedure GeneratorHttp://www.codeproject.com/cs/database/spgen.asp
Automatic memory of stored procedures:
Http://www.codeproject.com/dotnet/spinvoke.asphttp://codeproject.com/UserItems/spGenerator.asphttp://www.codeproject.com/cs/database/dbhelper.asp
Automatically generate data layers:
Suggested Data Layer Generators http://asp.net/forums/showpost.aspx?tabindex=1&postid=35928
Automatically generate related tools:
Llblgen Pro, The N-Tier Generator and O / R MapperHttp: //www.llblgen.comhttp://www.gavinjoyce.comHttp: //www.sharppower.comhttp: //www.alachisoft.comhttp: // www. DNZONE.COM/showdetail.asp?typeid=23&newsid=545
SQL Stored Procedure Wrapper & Typed Dataset Generator for .Nethttp://www.thecodeproject.com/cs/database/dbhelper.asp
Auto-Generating Wrapper Classes for Stored Procedures, Part 2: The Internals of the AutoSproc Toolhttp: //msdn.microsoft.com/data/default.aspx pull = / library / en-us / dndotnet / html / autointe2.asp #? Autointe2_topic2http: //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.comhttp: //weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx
Related Keywords: Stored Procedure Proxy Generator, dotNET NET 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