Eric Erhardt has posted part 1 of a series on using stored procedures in LightSwitch.  In the first part, he describes how you can execute a stored procedure when a user clicks a button on your LightSwitch screen.

The blog post is here – Executing a Simple Stored Procedure in LightSwitch.