Simple SQL Server Stored Procedure Wrapper
This template generates a class that can be used as a simple data access layer in many web applications, middle-tier components and web services.
Features and limitations
One method is created for each stored procedure in the database. Each method has strongly typed parameters that match the parameters of the associated stored procedure, including output parameters.
Each method returns a Dataset that contains the results of the stored procedure call.
The generated class also supports ad-hoc Sql queries with the ExecuteSql method.
This template is only officially supported against Sql Server 2000 databases. There is a decent chance that generation against Sql Server 7 will work as-is but it has not been tested by us at all.
This generated class can be very large if you have a large number of stored procedures so by default the "Allow-Real Time Previewing" has been turned off in this template.
This class is designed to be reusable, therefore it is a better practice to create one instance of this object and cache it, rather than creating new instances of the class every time you need a connection to the database.
Template Notes
This template generates a single class.
Version History
1.0.0 - Initial release.
1.1.0 - Added support for Visual Basic .NET.
1.2.0 - Changed Template Name, Corrected Execute Sql Bad Parameter, and Fixed Max Length issue on NText, Text, and Image data types.
