Adding and editing is buggy.

[Wuss Wuzz]

Adding and editing seems to be buggy

If I add a row to the table. Then I edit that row. everything is fine up to that point but once I add a new row, the changes in the previous row are undone (in the grid). At this point the gird is now out of sync with the database. I would need to browser refresh for the grid to reflect what is in the database.

I have tried every combination and when I think I finally have it working its not, it's either adding is an issue or maintaining an update is an issue, but never both can i have a proper update or proper add in the grid. It's either one or the other.  Something is wrong here.

[Wuss Wuzz]

It turned out that the issue was with EntityFramework caching data for the query I used to populate the datasource. After instructing EF to not cache for this specific query using "AsNoTracking" everything is now working as expected.

[Sarveswaran Palani]

Hi Wuss Wuzz,

Thanks for an update.

We suspect that, your issue has been resolved on your own. If you have any further queries, please get back to us.

Regards,
Sarvesh