Scheduler using LinqDatasource with link table

5 posts, 1 answers
  1. Developer
    Developer avatar
    5 posts
    Member since:
    May 2007

    Posted 07 May 2008 Link to this post

    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.
  2. Answer
    T. Tsonev
    Admin
    T. Tsonev avatar
    2817 posts

    Posted 13 May 2008 Link to this post

    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
  3. Developer
    Developer avatar
    5 posts
    Member since:
    May 2007

    Posted 15 May 2008 Link to this post

    Hi Tsvetomir,

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

    Cheers,
    Lee.
  4. Frank
    Frank avatar
    24 posts
    Member since:
    Nov 2010

    Posted 25 May 2011 Link to this post

    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
  5. Nikolay Tsenkov
    Admin
    Nikolay Tsenkov avatar
    734 posts

    Posted 27 May 2011 Link to this post

    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.

Back to Top