I am struggling with databinding the RadScheduler.
I have the tables created, the constraints/relationships set up just fine.
When I assign a resource to an existing appointment, the row is added to the AppointmentResource relationship table just fine into the database.
However, when I try to assign a resource to a new appointment, I get a constraint error.
When I remove the constraints, I see values like -4 in the AppointmentId column in the AppointmentResource table.
So, I'm assuming that, since the AppointmentId in the Appointment table is set to IDENTITY, the code that handles the relationships doesn't know the AppointmentId yet when creating the rows to add to the AppointmentResource table.
Is anyone aware of this, and do you have a workaround? I'm thinking the only workaround is to bind to objects and do the database code myself..
I have the tables created, the constraints/relationships set up just fine.
When I assign a resource to an existing appointment, the row is added to the AppointmentResource relationship table just fine into the database.
However, when I try to assign a resource to a new appointment, I get a constraint error.
When I remove the constraints, I see values like -4 in the AppointmentId column in the AppointmentResource table.
So, I'm assuming that, since the AppointmentId in the Appointment table is set to IDENTITY, the code that handles the relationships doesn't know the AppointmentId yet when creating the rows to add to the AppointmentResource table.
Is anyone aware of this, and do you have a workaround? I'm thinking the only workaround is to bind to objects and do the database code myself..