A CRUD based console application that allows the user to study with flashcards. Developed using C#/.NET and SQL Server.
- The program uses SQL Server to store and read information
- If no database exists a new one is initialized
- Most UI elements make use of the ConsoleTableExt Library to write the content in neat tables
- All Ids (flashcard's and stack's) are presented to the user sequentially starting from 1.
- If one Id's entry is deleted, the rest are updated to fill the gap.
- Study sessions allow the user to study a stack and all it's cards.
-
SQL Server
- Setting up was tricky, for whatever reason my installation didn't install with the default parametres, so I wasted a lot of time troubleshooting.
- Syntax - I had already worked with SQLite so the switch wasn't hard, just had to get used to it.
- Learning to use SQL Server Management Studio - Testing queries was extremely useful and time-saving.
-
Organization
- I think I did a good job separating concerns from the very start.
- I could still go further, but in projects of this scale (and that I know I don't want to expand) seems like wasted effort.
- I think I did a good job separating concerns from the very start.
- Became familiar with SQL Server while continuining to learn SQL
- Cemented previous knowledge in C#/.NET
- Keep learning SQL
- Make better use of KanBan boards. They're a powerfull tool for organization, but I end up forgetting I have one set up, so I don't use as much as I would like.
- The C#Academy Flashcard's project was the project guide.
- I reused a lot of code from my previous project.
- The C#Academy discord community that are always ready to help, and came in clutch with my SQL Server troubles (shout out to ghoulam!)
- The C#Academy coding coventions to help clean up the code and stick to the coding conventions.
- Various resources from all over the web.