Appointment Resources and Data Storage

[Michael Malone]

I'm using a master Appointments database table to store all appointments for RadScheduler that we use. That way I can share the same table whether it's a Dr. Appointment or a Vacation Schedule etc. I've added an "AppointmentType" column to the table to differentiate between appointment types. What I don't understand in this scenario is how to handle Resources. I don't want to store the ResourceType.ForeignKeyField in the master Appointments table because each type of Appointment may have zero to multiple Resources. I'd rather off-load Resources to another table so I don't clutter up the master Appointments table with FK Resource ID's for every possible Resource. Any ideas?

[Peter]

Hello Michael,

Please, review the sample from this forum post. The bottom line is to use DataSetHelper class with SelectDistinct method to create a separate datasource for your resource type.


Best wishes,
Peter
the Telerik team

[Michael Malone]

On the downloadable project in the link you sent, there is a Telerik.mdf  file included in the sample website... do I have to move this .mdf file to an actually Sql Server instance or can visual studio mount this as a "database" automatically?

[Peter]

Hello Michael,

Yes, you should be able to mount the database directly from Visual Studio. Actually, the following section in the web.config file is responsible for this:

web.config

<connectionStrings>
  <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Telerik.mdf;Integrated Security=True;User Instance=True"
   providerName="System.Data.SqlClient" />
 </connectionStrings>

 

Let me know if you experience any difficulties with this.


Regards,
Peter
the Telerik team