This question is locked. New answers and comments are not allowed.
I have quite complex model with lots of related entities which is mapped to real tables and several stored procedures for general purposes such as search, authentication and so on. According to new security requirements i need to map all my CRUD operations with tables to stored procedures. For example for table TBL1 i have 4 procedures:
select_TBL1(string securityToken)
update_TBL1(string securityToken, ...)
delete_TBL1(string secutiryToken, ...)
insert_TBL1(string securityToken, ...)
where securityToken is session identifier for user, stored procedures provide some security checks for this identifier.
So, i have some exact questions:
1.Can i map READ operation for table to stored procedure.
2.Can i map CUDs for tables to stored procedues with custom not reserved names such as sp_oa_ins_TBL1 and so on.
2.Can i provide implicit parameter in procedures which is not mapped to any table column.
Can you please advise me how to solve this task.
Thank you.
select_TBL1(string securityToken)
update_TBL1(string securityToken, ...)
delete_TBL1(string secutiryToken, ...)
insert_TBL1(string securityToken, ...)
where securityToken is session identifier for user, stored procedures provide some security checks for this identifier.
So, i have some exact questions:
1.Can i map READ operation for table to stored procedure.
2.Can i map CUDs for tables to stored procedues with custom not reserved names such as sp_oa_ins_TBL1 and so on.
2.Can i provide implicit parameter in procedures which is not mapped to any table column.
Can you please advise me how to solve this task.
Thank you.