在.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 (摘自李洪根博客)
[C语言系列]NET 中C#的switch语句的语法 [系统软件]托拽Explore中的文件到VB.net的窗口 [系统软件]Boost库在XP+Visual C++.net中的安装 [常用软件]新配色面板:Paint.Net3.0RC1官方下载 [常用软件]用内建的“Net Meeting”聊天 [VB.NET程序]Henry的VB.NET之旅(三)—共享成员 [VB.NET程序]Henry的VB.NET之旅(二)—构造与析构 [VB.NET程序]Henry的VB.NET之旅(一)—失踪的窗体 [VB.NET程序]在托盘上显示Balloon Tooltip(VB.NET) [VB.NET程序]Henry手记-VB.NET中动态加载Treeview节点(二)
|