I have a security model in place that only allows execute permissions on the database for the currently logged in users. What this means is that the user that is creating a schedule appointment doesn't have INSERT permissions... I have mapped all of my tables to stored procedures and have gotten everything working for the most part.
The problem I am having is that I can't find a way to map a stored procedure to my junction tables (i.e. I have a SaveSqlAppointment method and a SaveSqlResource method that are mapped to my SqlAppointments and SqlResources tables respectively. I also have a SaveSqlAppointmentResource method, but I cannot map that to my SqlAppointmentResources table via the Entity Framework designer.)
This scenario is throwing an error stating the current user cannot run INSERT on SqlAppointmentResources.
Is there a simple way to either implement this or bypass M2M4RIA for my INSERT and UPDATE methods? Any idea of what potential implications there are for adding SqlAppointmentResources to my Entity designer, creating 1-to-many relationships, removing my many-to-many relationships, and mapping my procedures that way?
The problem I am having is that I can't find a way to map a stored procedure to my junction tables (i.e. I have a SaveSqlAppointment method and a SaveSqlResource method that are mapped to my SqlAppointments and SqlResources tables respectively. I also have a SaveSqlAppointmentResource method, but I cannot map that to my SqlAppointmentResources table via the Entity Framework designer.)
This scenario is throwing an error stating the current user cannot run INSERT on SqlAppointmentResources.
Is there a simple way to either implement this or bypass M2M4RIA for my INSERT and UPDATE methods? Any idea of what potential implications there are for adding SqlAppointmentResources to my Entity designer, creating 1-to-many relationships, removing my many-to-many relationships, and mapping my procedures that way?