Discord.NET Bot Development (S2) · Working with databases · Episode 9 [OUTDATED, SEE DESC]
Disclaimer: Coding with Efehan has sadly stopped and hence, no new videos are uploaded. The videos can contain valuable content, but should be regarded with caution, as parts of it may be outdated. This includes all the repositories and libraries that are mentioned in the videos. It is highly recommended to follow the docs of the respective libraries. You can join Efehan's new Discord server at / discord , which also features programming support, if you need any additional support.
In the ninth episode of this season of the Discord.NET Bot Development series, we take a look into databases. How do they work? How do we set them up? How do we integrate them into our bot? We also investigate several best practices and ensure that our code is efficient and failproof.
00:00 - 01:45 | Introduction
01:45 - 07:00 | Installing MySQL
07:00 - 09:45 | Updating the configuration
09:45 - 14:52 | Creating data project & installing packages
14:52 - 22:53 | Setting up DbContext
22:53 - 25:13 | Creating a model
25:13 - 29:25 | Creating a migration
29:25 - 43:43 | Creating a data access layer (DAL)
43:43 - 47:12 | Setting up dependency injection (DI)
47:12 - 51:00 | Adding the DAL to custom ModuleBase
51:00 - 54:08 | Creating a prefix command (read/update)
54:08 - 01:00:49 | Creating a custom DiscordClientService
01:00:49 - 01:04:42 | Reading prefix in CommandHandler
01:04:42 - 01:08:58 | Best practices
01:08:58 - 01:09:59 | Shout-outs & end
GitHub repository: https://github.com/Coding-with-Efehan...
Visual Studio: https://visualstudio.microsoft.com/
Discord Developers: / discord
MySQL: https://dev.mysql.com
HeidiSQL: https://www.heidisql.com/download.php