I want it all and I have already generated the class and stored procedures. The problem is that when I call the Delete method, passing the PK, a DELETE T-SQL command is sent to the server instead of calling the delete stored procedure.

The way I set up my security, users can only call stored procedures. They have no rights to directly to the tables.

>Dan,
>
>>When I call a busines object's delete method, I want it to call a delete stored procedure passing a parameter for the PK value instead of creating and sending a DELETE T-SQL command.
>>
>>I want this behavior to be the default for ALL business objects. What is the best way to do this?
>
>Do you only want this for deleting or for inserts and updates too? The MM .NET Business Layer Generator allows you to use existing stored procedures (or creates new ones for you) and also creates corresponding data access classes.
>
>If you really only want to create a Delete stored procedure let me know...
>
>Best Regards,