Stored Procedure Wrapper Method Generator
Select the .NET version you are working with
Select the data provider you are working with
Enter the name of the stored procedure
Stored Procedure Name:
Select ExecuteScalar to read the data in the first column of the first row in the result set.
Select ExecuteReader to read all data in all columns of the result set.
Select ExecuteNonQuery if you don't need any results.
Type of Execution:
Enter the name of the method which wraps the stored procedure
Select the result type which is also the return type of the method, the corresponding SQL types are in parenthesis
Check the Nullable checkbox is the result can be a NULL value
Check this box if you want the method to return the stored procedure return value (other results will be returned as out parameters)