Skip to content

evaleyn5/csharp-sql-restaurant-system

Repository files navigation

🍽️ Restaurant Menu Management System

This project is a console-based application developed using C# and SQL Server. It allows users to manage restaurant menu items with category-based structure and CRUD operations.

🚀 Features

  • Add new products
  • List all products
  • Delete products
  • Update product information
  • Category-based menu system (Starter, Main Course, Dessert)

🛠️ Technologies Used

  • C#
  • .NET Console Application
  • SQL Server
  • ADO.NET

📸 Console Preview

Add Product

Add Product

List Products

List Products

Update Product

Update Product

Delete Product

Delete Product

🧠 What I Learned

  • Database connection and management with SQL Server
  • Performing CRUD operations using ADO.NET
  • Writing SQL queries and managing relational data
  • Building console-based backend applications

📂 Database Structure

TbsCategory

  • CategoryId (int)
  • CategoryName (nvarchar)

TbsProduct

  • ProductId (int)
  • ProductName (nvarchar)
  • ProductPrice (decimal)

⚙️ How to Run

  1. Clone this repository
  2. Open in Visual Studio
  3. Update connection string if needed
  4. Run the project

📌 Notes

This project was developed as part of my backend development learning process.

👩‍💻 Developer

Aleyna

About

C# & SQL Server Console Restaurant Management System with full CRUD operations

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages