If you often use stored procedures, you certainly know how tiresome it is to write one and the same code defining the name, the type and the size of every parameter every time you want to call the command object. And if you happened to change the interface of the stored procedure, you most likely had to return to your data access layer and correspondingly modify the calling of the stored procedure. Programmers are ready to do anything to simplify the process: to centralize the calling of stored procedures at the data access layer, to write wrappers round them, and even implement automatic generators.
The Stored Procedure Proxy Generator program is designed for the radical simplifying of this problem solution. Based on the information taken from the specified database it builds .NET-assembly with a set of methods representing proxies for all (or the chosen) stored procedures of the database. After that the calling of the stored database is an elementary call of the built proxy method.
Keywords:
dotNET
NET
Framework
Stored
Procedure
Proxy
Generator
SQL
Server
Database
C#
Visual
Basic
Wrapper
Assembly
Reflection
Emit
|
