自动产生SQL SERVER存储过程

在.NET开发中,自动产生SQL SERVER存储过程:

如对表操作的ADD / DELETE / UPDATE /GetSingleRow

我推荐的方法:

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

存储过程的自动调用:

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

自动生成数据层:

Suggested Data Layer Generators   
http://asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=35928

自动生成数据层的相关工具:

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 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

评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值