ID with multiple fields

[Chris]

I have a database table that has a primary key made up of multiple columns. Is there a way for a grid to support this? I am using a WCF Data Service for the data. So ideally I would like to take advantage of the odata support. I can create the URL myself for the operations, microsoft does support multiple keys when doing a put or delete. Or is there a way to use the grid without a model? I was having issues with adding/editing data when I didn't use a model. If I don't have an id field on the model the grid seems to get confused about which models are new and tries creating all of them again.

Thanks,
Chris

[Dimo]

Hello Chris,

I am afraid that the Kendo UI datasource currently does not support composite keys. You should address this on the server, for example if you are using MVC, create a ViewModel, which has a single key field.

Grid editing requires a model and an ID definition:

http://docs.kendoui.com/getting-started/web/grid/editing

Regards,
Dimo
the Telerik team

[Gal]

Hi I see there is no solution yet for this issue and I solved it on the client using the parse: 

 

parse: function (response) {
                       for (var i = 0; i < response.Data.length; i++) {
                           response.Data[i].id = "" + response.Data[i].TenentID + response.Data[i].OrderNumber + response.Data[i].Activity;

                       }
                       return response;
                   }

[Steve]

I used a pseudo key as suggested here: https://www.telerik.com/forums/composite-datakey-in-kendo-ui-mvc#JlhcEtSyAEqMWaW6TjnDKQ