Flashcards Console App

This is a simple console-based flashcards application developed as part of The C# Academy's learning projects. It serves as a practical exercise to reinforce fundamental C# programming concepts.

Overview

The Flashcards Console App allows users to create, view, and manage flashcards directly from the command line with an interactive better looking UI. It's designed to help learners practice and memorize information effectively.

✨ Features

• Manage Stacks: Create, view, update, and delete stacks of flashcards
• Manage Flashcards: Add, edit, and remove flashcards within stacks
• Study Mode: Test your knowledge by viewing questions and checking answers
• Session Tracking: Keep records of study sessions with scores
• Monthly Session Tracking: View the number of study sessions per stack organized by month
• Performance Analytics: See average scores per stack broken down by month
• Pivot Table Reports: Display data in easy-to-read pivot table format showing:
  • Monthly trends in study habits
  • Performance improvement over time
  • Comparison between different stacks

🛠️ Technologies Used

• C# (Console Application)
• .NET (Latest version recommended)
• Dapper (Micro-ORM for database interactions)
• SQL Server
• Spectre.Console (For better console UI)

📜 Lessons Learned

• Use Sql Server and link it to a c# project.
• Deal with multiple tables with relationships between them.
• Learn about pivot tables and use it to get an appropriate view for reports.
• A basic knowledge about MVC design pattern.

📚 Project Source

This project was inspired by the Flashcards project from [The C# Academy] in this link. It helps improve C# skills, database work, and console app development.