This is a migrated thread and some comments may be shown as answers.

Recommended WCF RIA Implementation/Table Structure?

3 Answers 89 Views
ScheduleView
This is a migrated thread and some comments may be shown as answers.
Scott
Top achievements
Rank 1
Scott asked on 12 Apr 2011, 12:21 AM
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

3 Answers, 1 is accepted

Sort by
0
George
Telerik team
answered on 15 Apr 2011, 10:28 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Scott
Top achievements
Rank 1
answered on 16 Apr 2011, 12:41 AM
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
0
schneeflocke
Top achievements
Rank 1
answered on 10 Jan 2012, 05:08 PM
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
Tags
ScheduleView
Asked by
Scott
Top achievements
Rank 1
Answers by
George
Telerik team
Scott
Top achievements
Rank 1
schneeflocke
Top achievements
Rank 1
Share this question
or