The edit method does not edit the pre-existing data but it creates a new data entry with NULL
I am super confused with how unexpectedly my ASP.NET app behaves which was supposed to be a simple CRUD. My app has a huge problem with editing the pre-existing data row via frontend. I totally appreciate a second set of eyes.
Please see the attached video https://imgur.com/a/nh6GDih- the app shows the empty text field once the Edit button is clicked. Once the save button is clicked I got the message user edited as per screenshot attached.
However, in my DB my user input has been saved as a new entry instead of edit for "palace of hormisdas"
`mysql> SELECT * FROM ListingDTO_DBTable;+----+---------------------+| Id | ListingName |+----+---------------------+| 3 | palace of hormisdas |. <----- this is super strange! at Id 3 the ListingName has not been edited at all! | 36 | NULL | <----- instead a new entry has been created with a new Id and a new NULL value! the user input has not been saved at all+----+---------------------+2 rows in set (0.00 sec)
`mysql> SELECT * FROM ListingDTO_DBTable;+----+---------------------+| Id | ListingName |+----+---------------------+| 3 | palace of hormisdas |. <----- this is super strange! at Id 3 the ListingName has not been edited at all! | 36 | NULL | <----- instead a new entry has been created with a new Id and a new NULL value! the user input has not been saved at all+----+---------------------+2 rows in set (0.00 sec)
I wanted to see that the entry with Id 3 has the edited ListingName (not "palace of hormisdas" anymore but whatever value I enter via Edit UI