Recommended WCF RIA Implementation/Table Structure?

[Scott]

Hi,

This thread is related to another thread titled, "database table structure." Sorry for the overlap, but we're struggling to understand the recommended approach for persisting RadScheduleView Appointments to the database via WCF RIA Services. Questions:

1. Do you have a more refined reference implementation solution similar to ScheduleView_EF_SL.zip?
2. What is the proper structure for persisting Appointment recurrences and recurrence exceptions?
3. Are you sticking with a virtually duplicated SqlAppointment entity (SqlExceptionAppointment) as the means to store recurrence exceptions?

The MVVM-related improvements to the RadScheduleView relative to the RadScheduler are excellent--thank you. However the ScheduleView_EF_SL sample is a bit confusing because of the switch away from implementing exceptions storage as self-referencing SqlAppointments. In addition, there appear to be columns left over from the self-referencing example (SqlAppointments.ParentId for example) that do not appear to be used in the sample.

Because we have a large solution, changing our database schema, Entity Framework data model, WCF RIA Service meta-data classes, and RIA [query], [update], etc., classes is a time-consuming operation. I want to be sure I head down the recommended path sooner rather than later.

Thanks,
Scott

[George]

Hi Scott,

 
Thank you for contacting us again.

I answered to some of your questions in the other thread. Our goal is to make as much as possible the RadScheduleView data binding MVVM friendly.

The project is just an example how to achieve the scenario. Anyway, we left some of the properties blank because they require custom logic. 

Please do not hesitate to contact us if you require any further information.

Best wishes,
George
the Telerik team

[Scott]

Hi George,

Thanks for the info. Our biggest dilemma was how to implement the persistence of recurrence-related objects. Your description of them as distinct entities makes sense so we will add SqlException* tables/entities in addition to SqlAppointment table, and we'll remove the self-referencing bits.

Cheers,
Scott

[schneeflocke]

Hi Scott,

in your solution, have you used the M2M4Ria Logic as provided in the Telerik sample or was it not necessary to be used in your solution?

Thanks

Stefan