Calling Stored Procedure

To call a stored procedure:

Create a new instance of the class that represents a connection to the database.
Get the stored procedure collection object and call one of the stored procedure wrapping methods.
Close the connection to the database.

Methods	Description
`<StoredProcedureCodeName>Command(<stored procedure parameters>)`	Creates a command object that can be used to call the wrapped stored procedure.
`<StoredProcedureCodeName>DataTable( <stored procedure parameters>)`	Invokes the wrapped stored procedure and returns output data in a DataTable object.

For example:

[C#]

using(MyDatabase db = new MyDatabase()) { // Call the GetUsersByZip stored procedure and return data in a DataTable object DataTable users = db.StoredProcedures.GetUsersByZipDataTable(77057); // You do not need to close the DB connection manually. // The using statement does it automatically. }

MyDatabase db = new MyDatabase(); try { // Call the GetUsersByZip stored procedure and return data in a DataTable object DataTable users = db.StoredProcedures.GetUsersByZipDataTable(77057); } finally { // Do not forget to close the DB connection db.Close(); }

VB.NET

Dim db As New MyDatabase()

			Try 
			

			    ' Call the GetUsersByZip stored 
					procedure and return data in a DataTable object

				    Dim users As DataTable =
				  db.StoredProcedures.GetUsersByZipDataTable(77057)

			Finally
			

			    ' Do not forget to close the DB connection
			

			    db.Close()

			End Try