Composite DataKey in Kendo UI MVC?

[Nick]

I have a pretty basic data model that I'm trying to bind to a grid but I get stuck on the implementation on how to bind this specific object because it's primary key is a composite of two different columns. I'm using the Kendo UI MVC Beta at the moment. Any suggestions on how this is done? I haven't had much look searching so far.

My two columns I need for the Id are ContactNumber and ClientNumber. Below I have ContactNumber only so far.

Edit: Crap, I just noticed there are dedicated forums for the MVC version of Kendo UI. I don't suppose a moderator could move this for me?

@(Html.Kendo().Grid(Model)

    .Name("Grid")

        .Columns(columns =>

            {

                columns.AutoGenerate(true);

                columns.Command(command =>

                    {

                        command.Edit();

                        command.Destroy();

                    });

            })

    .ToolBar(toolbar => toolbar.Create())

    .Editable(editable => editable.Mode(GridEditMode.PopUp))

    .DataSource(dataSource => dataSource

        .Server()

        .Model(model => model.Id(p => p.ContactNumber))

            .Read(read => read.Action("Index", "ContactRep"))

            .Update(update => update.Action("Edit", "ContactRep"))

            .Create(update => update.Action("Create", "ContactRep"))

            .Destroy(update => update.Action("Delete", "ContactRep")))

    .Pageable()

    .Sortable()

    .Filterable()

    .Groupable())

[Petur Subev]

Hello Nick,

The Kendo datasource does not support composite data keys. However those should not be needed in order to implement your scenario. The data source needs the ID field only to determine new models from the existing ones. The whole model is submitted during an update and you have both fields available on the server.

All the best,
Petur Subev
the Telerik team

[Tom]

One way to achieve this, if you really need the compound key, is to create a pseudo id field which has your concatenated/compound ids on the server side (perhaps returned as a string with pipe-separated values), which you can then feed to the grid data object - you can then reference this pseudo field when doing your CRUD operations.

[Larry]

It there support for composite keys in the current MVC release?

[Konstantin Dikov]

Hi Larry,

The DataSource is still not supporting composite keys, but you could try the suggestion with the pseudo id field from the previous post.


Best Regards,
Konstantin Dikov
Progress Telerik

[koms]

Hi,

Can I know whether Telerik Grid View DataSource is supporting composite keys now?

Thanks

[Konstantin Dikov]

Hi Kaumil,

This is still not supported, but you could give a vote for the following feature request and increase its priority:

• https://feedback.telerik.com/kendo-jquery-ui/1358261-support-composite-keys-in-the-datasource-id-property

Best Regards,
Konstantin Dikov
Progress Telerik