How do you call a Stored Procedure in NOP 1.9?

If I create my own Stored Procedure in SQL Server,
how can I use the code or data access layer in NOP 1.9 to call it?

I know I can use something like this if I have to:

conn = new SqlConnection("Server=(local);DataBase=Northwind;Integrated Security=SSPI");
conn.Open();
SqlCommand cmd  = new SqlCommand("Ten Most Expensive Products", conn);    
cmd.CommandType = CommandType.StoredProcedure;
rdr = cmd.ExecuteReader();

but if there is already a mechanism available for me to call a stored procedure
I'd rather use that. Thanks

...