,自动产生SQL SERVER存储过程:

    技术2022-05-12  6

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

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

    我推荐的方法:

    ADVANCED T-SQL:Automate the Generation of Stored Procedures for Your Databasehttp://msdn.microsoft.com/msdnmag/issues/03/04/StoredProcedures/default.aspx

    SPGen - Stored Procedure Generatorhttp://www.codeproject.com/cs/database/spgen.asp

    存储过程的自动调用:

    http://www.codeproject.com/dotnet/spinvoke.asphttp://codeproject.com/useritems/SPGenerator.asphttp://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 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.comhttp://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


    最新回复(0)