ASP.NET MVC Grid - columns not updated after Edit->Put / ODATA / EF

[Andreas]

Hi, I am trying to get it to work with the controller generated by visual studio for ODATA V3 and EF. The grid initially renders well and shows all data.

This is the code for Put. After a successful Put my record gets updated and code 204 is returned as far as I know. But no data is returned and the grid is not updated to the change. How can I get the grid updated after the put? A page reload shows the correct grid.

Controller:

       // PUT: odata/TodoItems(5)

        public IHttpActionResult Put([FromODataUri] string key, Delta patch)

        {

            Validate(patch.GetEntity());

            TodoItem todoItem = db.TodoItems.Find(key);

            if (todoItem == null)

            {

                return NotFound();

            }

            patch.TrySetPropertyValue("CreatedAt", todoItem.CreatedAt);

            patch.Put(todoItem);

                db.SaveChanges();

 

            return Updated(todoItem);

        }

Grid:

   @Html.EJS().Grid("OData").DataSource(dataManger =>

 {

     dataManger.Url("/odata/TodoItems").CrossDomain(true).Adaptor("ODataAdaptor");

 })....

[Hariharan J V]

Hi Andreas, 

  

Thanks for contacting Syncfusion support. 

  

We have analyzed your query and the codes which you have shared with us. We suspect that the problem is with the way you are returning the result from the server side “Put” method. We suggest you to return the result from the server side method as a Json. Please refer the code example below, 

  

        // PUT: odata/Products(5) 

        public IHttpActionResult Put([FromODataUri] int key, Delta<Product> patch) 

        { 

            .  .  . 

            return Json(product);     //Return as Json 

        } 

  

  

And also we suggest you to ensure whether you have provided “isPrimaryKey” for a column in Grid, as based on the primary key column only, the CRUD actions will take place. 

Documentation : 

https://ej2.syncfusion.com/aspnetmvc/documentation/grid/edit/?no-cache=1#editing 

https://ej2.syncfusion.com/javascript/documentation/api/grid/column/#isprimarykey 

  

If you are still facing the problem, please get back to us with the following details, 

1. Share the full Grid code.
2. Share the screenshot of the post from the network tab.

  

Please get back to us if you need further assistance. 

  

Regards, 

Hariharan 

[Andreas]

Hariharan,

Thanks a lot! Your proposed solution works like charme. Wouldnt it be good to mention this in the documentation. Its really hard to figure out.

return Json(product);     //Return as Json 

Thanks you so much,

Andreas

[Hariharan J V]

Hi Andreas, 

  

Thanks for your update. 

  

We are happy to hear that your issue has been resolved. And we have logged this scenario in our documentation task and which will available in any of our upcoming releases. 

  

Regards, 

Hariharan