HOME         User: Anonymous search for  in 


Registered User Functions:
  1. Register New Account
Anonymous Functions:
  1. Home
  2. Users
  3. Archives
  4. Templates
  5. Articles
  6. MyGeneration Website
  7. MyGeneration Forums
    Application Type
    1. Command Line
    2. Graphical User Interface
    3. Library
    4. Sample
    5. Web Application
    Architecture Type
    1. Client-Server
    2. Distributed Computing
    3. Multi-Tier
    4. Peer-to-peer
    Operating System
    1. Linux
    2. Win32
    Programming Language
    1. ASP
    2. ASP.Net
    3. C#
    4. C++
    5. Firebird SQL
    6. J#
    7. Java
    8. Jet SQL
    9. JScript
    10. JSP
    11. MySQL
    12. Perl
    13. PHP
    14. PL/SQL
    15. PostgreSQL
    16. SQL
    17. Transact-SQL
    18. VB.Net
    19. VBScript
    20. XSLT
    Archive: VB.NET - Enterprise Library - Data Access Application Block - Generate Stored Procedure Class
    Author: justind
    Created: 1/10/2010 1:33:35 AM
    Last Updated: 1/10/2010 1:33:35 AM

    This template lets you select multiple stored procedures and then will generate a StoredProcedure.vb class for you. The class will contain auto-generated DAAB syntax to call the stored procedures you chose to script. You can choose to return a DataSet, DataTable, DataReader, Datarow, or ExecuteScaler (return nothing). It also lets you optionally type the name of your DAAB connection string and will include it in the generated code. You can create static (shared) methods or instance methods. This template was written against Enterprise Library v 4.1. It can take a while to populate the list box of stored procedure names so please be patient as the template executes. In my case, I had 1500 stored procedures in my database and it took 2 minutes to populate the list box of proc names. Generating the StoredProcedure.vb class though is very quick - almost instant. Hopefully someone will take the template and adjust it to work with C#.NET too. It is pretty easy to follow the template syntax - I split up the template operations into very small subs to make it easier for C#.NET scripters to create a C#.NET version.
    Templates (by Title)
    No matching records found.
    Files (by FileName)
    Date UpdatedFileNameFile TypeFile SizeUsername# Downloads
    1/10/2010 vb_net_stored_proc_wrapper_enterprise_library.zip Unknown4235 justind 1751
    Articles (by Title)
    No matching records found.
    Related Archives (by Title)
    No matching records found.
    Messages (by Date Created)
    No matching records found.
    Copyright © 2004 MyGeneration Software. All rights reserved.
    Feedback: feedback@mygenerationsoftware.com
    Support: support@mygenerationsoftware.com