I am very excited about the ORM product and I am making some great progress but I am having trouble with the simple stored procedures. I am NOT using them as CRUD procedures and instead would rather have the ORM handle insert/update/deletes out of the box. I am interested in calling a stored procedure before the application makes any changes to the database for internal audit purposes and security. I have tried to reverse this into my model but it comes in without any parameters. Here is what I get:
Here is the original stored procedure declaration:
My issues is twofold:
a) How can I get the top procedure defined so it works properly (please just paste the complete code)
b) If I modify this in the cs file under my model, it will be removed if I reverse engineer the model again, so how can I execute a procedure in the same scope as my object updates? (again, an example would be great).