Sample Database

[RAHUL]

Hi
I have started working on Telerik scheduler few days back.
I am facing problems in database structure.
I want to know Whether in Appointments table the RecurrenceParentID is a foreign key to the ID of same table or not? Please clear this with detail of RecurrenceParentID and how can i use it ..

[Plamen]

Hi Rahul, 

 
The RecurrenceParentID field is not a foreign key to the ID. You can refer to this help article where is provided more information about the DataBase structure.

Hope this will be helpful.

All the best,
Plamen Zdravkov
the Telerik team

[RAHUL]

hi zdrakov
can you clarify what is the intent behind using RecurrenceParentID. Actually i could not get a clear idea from the help(as in article) .
 if possible please show with  an example.
What is the significance of the constraint provided in article of DataBase Structure?

CONSTRAINT [FK_Appointments_ParentAppointments] FOREIGN KEY  
       ([RecurrenceParentID])  
   REFERENCES  
       [Appointments] ([ID]),

[Plamen]

Hi Rahul,

 
It seems that I could not understand the questions properly and provided not very clear answer. Please excuse me for that. The RecurrenceParentID  field is used as a foreign field in cases when an exception is created in a recurrence serie. In that moment a new appointment is created in the database that is how this exception is actually connected with the initial recurrence serie.

You can also refer to this help topic where is explained how to bind a RadScheduler declaratively

I am attaching a sample project with RadScheduler bound to DataSource. Hope this will explain the issue better.

Kind regards,
Plamen Zdravkov
the Telerik team