Stored Procedure Wrapper Method Generator

Select the .NET version you are working with
.NET Version:

Select the data provider you are working with
Data Provider:

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: 

Click this button to add Stored Procedure Input Parameters
 


  
Enter the name of the method which wraps the stored procedure
Method Name:

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

Result Type:

Check this box if you want the method to return the stored procedure return value (other results will be returned as out parameters)