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

Scheduler using LinqDatasource with link table

4 Answers 106 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Developer
Top achievements
Rank 1
Developer asked on 07 May 2008, 04:08 PM
Hi,

I'm having a look at creating a scheduler which uses Linq as a datasource. I've read through your guide on doing this which I found under another forum post:

http://www.telerik.com/support/kb/article/b454K-meb-b454T-cth-b454c-cth.aspx

This was great, thanks. One thing I would like to do that I can't seem to figure yet is how to add a resource where the items are from another table, but only associated with the appointment via a link table.

I'm trying to get a list of 50 or so items under the resources as checkboxes.. then ticking an item saves an entry in the link table.

I've set up the linqdatasources, but I'm not sure the ForeignKeyField can work like this. Anyone had any success doing something like this?

Thanks,
Lee.

4 Answers, 1 is accepted

Sort by
0
Accepted
T. Tsonev
Telerik team
answered on 13 May 2008, 11:45 AM
Hello,

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,
Tsvetomir Tsonev
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
0
Developer
Top achievements
Rank 1
answered on 15 May 2008, 10:36 AM
Hi Tsvetomir,

I've managed to get that working using the provider example, thanks a lot. great stuff :)

Cheers,
Lee.
0
Frank
Top achievements
Rank 1
answered on 25 May 2011, 03:59 PM
Hi Tsvetomir / Telerik,

Below you say:
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.

Is this sample or article of the LINQ version of a provider already available? I wasn't able to find is in the KB or on the forums.

Soon I will have to implement it myself and a good sample is always very welcome!

Thanks Frank
0
Nikolay Tsenkov
Telerik team
answered on 27 May 2011, 09:33 AM
Hello Frank,

We haven't implemented the sample provider, yet.
The task will be logged and as soon as we prepare it, we will notify you in this same thread.


Regards,
Nikolay Tsenkov
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Tags
Scheduler
Asked by
Developer
Top achievements
Rank 1
Answers by
T. Tsonev
Telerik team
Developer
Top achievements
Rank 1
Frank
Top achievements
Rank 1
Nikolay Tsenkov
Telerik team
Share this question
or