when you reverse map your tables you can switch to advanced tab in the reverse mapping wizard. From there you can select any class and check the Use stored procedure
check box. A list with available stored procedures will appear and from there you can specify whether to use Dynamic SQL(meaning that every time when you add for example a new SQL statement will be generated) or you can select create stored procedure which will generate a new stored procedure on your SQL server and that stored procedure will be used the next time you try to add an object.
All the best,
the Telerik team