Today, I will show you how to solve the Microsoft SQL exception invalid column name for a particular case scenario in an e-commerce application.
Hello guys! While working on an e-commerce shopping cart application with asp.net, I encountered an error stating 'invalid column name quantity'. I realized that there was no 'quantity' column in the product table, even though I had upgraded the product model to include it. To solve this problem, I used the Package Manager Console to add a migration for the 'quantity' column and update the database. However, since the table already existed with data, I had to manually delete the table and recreate it. After successfully solving the error, I ran the application and verified the updated database.
Thank you very much for watching!
video txt