1. Create an instance of connection to the database, a SqlConnection object.
2. Create an instance of a SQL command, a SqlCommand object.
3. Mark the command as a stored procedure.
4. Execute the command.
5. Return the SqlDataReader result to the caller.

Here's an example. The ProductsDB.js file includes the method GetProductCategories(). As the name implies, this method retrieves the product categories from the database. It follows the recipe above, calling the stored procedure ProductCategoryList. This stored procedure is the simplest one, as it doesn't expect any parameters. It returns a table of all product categories in the databases. Here's the code:

  public function GetProducts(categoryID: int) : SqlDataReader {
    var myConnection : SqlConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
    var myCommand : SqlCommand = new SqlCommand("ProductsByCategory", myConnection);
    myCommand.CommandType = CommandType.StoredProcedure;
    var parameterCategoryID : SqlParameter = new SqlParameter("@CategoryID", SqlDbType.Int, 4);
    parameterCategoryID.Value = categoryID;
    myCommand.Parameters.Add(parameterCategoryID);
    myConnection.Open();
    var result : SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
    return result;
  }

People who read this tip also read these tips:

• Boosting Performance by Avoiding Dots
• On-the-Fly XML to HTML Conversion
• Converting Dimensions for Printing
• Asynchronously vs Synchronously
• The SqlConnection Class