Invalid object name 'MenuItem' (or other tables)
If you encounter a SQL Exception stating "Invalid object name 'TableName'" when running locally, it means your local SQL Server Database (RestaurantDB) is missing the tables required for Lab 10.
How to fix:
- Open SQL Server Management Studio (SSMS).
- Connect to your local server (usually
localhost\SQLEXPRESS). - Open the script file located at
Lab_10/DB/setup_somee.sql. - Execute the script to create the missing tables and insert the sample data.
- Restart your application.
Test Credentials for Login
Use the following test credentials to access different roles in the application:
- Manager: Username:
manager| Password:owl123 - Waiter: Username:
waiter| Password:broom123 - Customer: Username:
Ahmad Khan| Password:cust123