Unfortunately, RadScheduler will not be able to handle this scenario by using standard data source controls. In order to achieve this result, you will need a custom provider. We have an example
and a documentation article
that demonstrate how to create and use a custom provider. The sample provider uses a link table to store the associations between appointments and resources, much like in your case. You can use it as a reference and replace the SQL queries with LINQ. Note that you should inherit from SchedulerProviderBase instead from
DbSchedulerProviderBase, as you do not need the database-related functionality.
Authoring a custom provider is more difficult than using standard data source controls and we will be happy to assist, should you decide to implement one. In fact, we are planning to introduce a LINQ version of the provider described in the help article. Hopefully, we will have the chance to do this soon.
All the best,
the Telerik team