Delete Action not deleting in SQL Server database - UI changes locally to show it "disappearing" but on page refresh, data is still there

[Tinkerer Duty]

Hi all,

I hope you are all well.

I'm having a bit of an issue with the Delete action.

I'm following this guide in the documentation:- https://blazor.syncfusion.com/documentation/common/data-binding/bind-entity-framework - and everything is working perfectly (like the add, update etc) but right at the end when I have implemented the delete functionality via clicking the delete button and it deleting the data entry in the database by id, it shows the entry deleting in the browser, but when refreshing the page the data entry is still there and in the database it doesn't delete.

Please see attached gif for reference- it shows me deleting an entry from the database but then when i refresh the page, the entry comes back and isn't deleted!

I hope you can help me :)

Many thanks

Attachment: gif_d527733f.rar

[Sarveswaran Palani]

Hi Tinkerer,

Greetings from Syncfusion support.

From your query, We suspect that you’re facing issue in deleting operation. We have prepared sample based on your requirement, but we’re unable to reproduce any issue while deleting. We request you to share video demo of an issue or share the issue reproducible sample to us. It’ll be helpful for us to further validate your query and provide solution ASAP from our end.

Regards,
Sarvesh

Attachment: BlazorAppEFFK_b801f6f9.zip

[Tinkerer Duty]

Hello Sarveswaran :)

Thanks for the swift response.

From checking your file out and making some additional changes, nothing seems to be reflectingin the database.

I'm still clicking on delete and nothing is changing; the browser ui changes but not after refreshing and in the database.

Please see video of my code:-

https://www.veed.io/view/2f1d6a81-b42f-43ba-b8e1-47e327bc1d8f?panel=share

...the gif I've sent over in the previous zip is it looks like on the browser side when clicking delete and then refreshing the page.

I hope you can help me and I look forward to hearing from you!

Many thanks

[Tinkerer Duty]

Hello again,

I hope this message finds you well.

I've managed to resolve this problem! - It was such a simple fix yet I went down rabbit whole after rabbit whole- I ended up learning so much out of this process in spite of this so all turned out brilliantly!

Many thanks for all your help anyway!

Kind regards

[Prathap Senthil]

Thanks for the update,

We are happy to hear that the issue has been resolved on your end. If you have any further questions, please do not hesitate to reach out to us.