Crud ej2 grid using EF and SQL database and Remote Save Adapter

[Edmund Herbert]

Hi Guys,

I have been trying to create a Grid with crud using EJ2 framework and core 3.1 using Entity Framework Code First ánd Remote Save Adapter , connecting to Microsoft SQL database I am not having any luck when trying to insert new record grid is not updating, do you have example code to above.

Regards

Edmund Herbert

Hi is anybody in support looking into this

[Ajith Govarthan]

Hi Edmund, 

Thanks for the update. 

Based on your requirement you want to insert new record and update in them using the remoteSaveAdaptor based on that we suspect that your are using the normal edit mode in your grid application and we have shared the code example and documentation to insert the record at the server side. So please refer the code example and documentation for your reference. 

For Insert operation : 

HomeController.cs 

 

public async Task<ActionResult> Insert([FromBody]CRUDModel<Orders> param) 

        { 

            _context.Orders.Add(param.Value); 

            await _context.SaveChangesAsync(); 

            return Json(param.Value); 

 

        } 

For Update operation : 

HomeController.cs 

 

public async Task<ActionResult> Update([FromBody]CRUDModel<Orders> param) 

        { 

            _context.Orders.Update(param.Value); 

            await _context.SaveChangesAsync(); 

            return Json(param.Value); 

        } 

For Delete operation : 

HomeController.cs 

 

public async Task<ActionResult>  Delete([FromBody]CRUDModel<Orders> param) 

        { 

           Orders value = _context.Orders.Where(e => e.OrderID == Int32.Parse(param.Key.ToString())).FirstOrDefault(); 

            _context.Remove(value); 

            await _context.SaveChangesAsync(); 

            return Json(value); 

        } 

Index.cshtml 

<ejs-grid id="Grid" allowPaging="true"  height="300" toolbar="@(new List<string>() {"Add", "Edit", "Update", "Delete" })"> 

  <e-data-manager json ="@ViewBag.dataSource" adaptor="RemoteSaveAdaptor" insertUrl="/Home/Insert" updateUrl="/Home/Update" removeUrl="/Home/Delete" ></e-data-manager>    <e-grid-columns>    

     …     

    </e-grid-columns> 

</ejs-grid> 

UG-Links: 

https://ej2.syncfusion.com/aspnetcore/documentation/grid/data-binding/#remote-save-adaptor 

https://ej2.syncfusion.com/aspnetcore/documentation/grid/edit/#insert-record 

if you still face the issue then please share the below details to validate further on your requirement. 

1. Share the complete grid rendering code example and the server side codes.

2. Share the screenshot or video demonstration of the issue.

 

3. Share the Syncfusion package version

Regards, 

Ajith G. 

[Edmund Herbert]

Thanks Guys

Just what I needed

[Ajith Govarthan]

Hi Edmund, 

Thanks for your update. 

We are happy to hear that your issue has been resolved. 

Please get back to us if you need further assistance. 

Regards, 

Ajith G. 

[Edmund Herbert]

Hi

I implemented data grid as per your example, i also tried your core console and created Grid app,  on both apps when you insert record value to be inserted is null

what am i doing wrong here

Please see attached image

Attachment: Screenshot_20201009_155449_c8825106.zip

[Edmund Herbert]

Hi OK worked out insert record all fields must have values now I have issue that grid does not show inserted record please see attached image

i used workaround where i reloaded page but that is not how grid should wo

Attachment: Screenshot_20201009_162926_b17483dc.zip

[Edmund Herbert]

Hi,

I have attached example project that has insert record issue

Regards

Edmund Herbert

Attachment: TeamsTechTrack_55989c83.zip

[Atli]

Hello Edmond,

I have been following this thread because I am trying to achieve similar functionality with ASP-Net Core 3 and Entity Framework.  Have you tried to add a new controller, selecting "New Scaffolded Item" and then select the "Syncfusion ASP.NET Core UI Scaffolder".  This generated code for me that worked at least partially.

I also look forward to a more detailed reply from Syncfusion.

regards

Atli

[Atli]

Hi again Edmund,

You also have to choose "Remote Data" as Data Source Type:

[Edmund Herbert]

Hi,

I have resolved issue forgot isIdentity="true" in Id field all working now thank you for your support

Regards

Edmund Herbert

[Ajith Govarthan]

Hi Edmund, 

Thanks for your update.  

We are happy to hear that your issue has been resolved.  

Please get back to us if you need further assistance.  

Regards,  

Ajith G.