I am trying to evaluate Scheduleview with OpenAccess.
My Scenario seems to be simple.
- Create an Appointment
- Assign Resources
- Update Resource
Since WCF Ria doesnt support many to many relationship and i cannot find any help for M2M4Ria with OpenAccess, i decided to do all this manually.
I followed the table template according to guideline for working with database with Scheduleview explained here
, I modified the Model to work with WCF and recreate the link table as described here
. Now i am successfully able to create a new SqlAppointment, Assign Resource to an Appointment via codebehind. (btw, i created a saperate page just to assign resources to Appointments)
Problem : now the problem is, when i want to update the resource, i cant seem to find a way to do it. i guessed i need to remove the 'SqlAppointmentResources' relation entry and then submit changes, but submit change takes forever and then come back with error of timeout.
Is there anyway we can work with OpenAccess with Scheduleview? can you refer me any links which can help implement M2M4Ria with OpenAccess? i am asking this because in your example with Scheduleview you used M2M4Ria but with Entity Framework. Does OpenAccess even support this kind of scenario?
Thanks for your help