For the simplicity we will use MSSQLProvider to fetch the data from the database. This class has basic functionality, if you want to create complex database queries, for example JOIN, you'd better use something like Entity Framework. - Source: dev.to / about 2 months ago

I only wanted to give a simple preview of what can be done with Entity Framework, but if this is something that interests you and you want to go further in-depth with all the possibilities, I recommend checking out the official docs where you can also find a great tutorial which will guide you through building your very own .NET Core web application. - Source: dev.to / about 1 year ago

Entity Framework documentation hub - Entity Framework is a modern object-relation mapper that lets you build a clean, portable, and high-level data access layer with .NET (C#) across a variety of databases, including SQL Database (on-premises and Azure), SQLite, MySQL, PostgreSQL, and Azure Cosmos DB. It supports LINQ queries, change tracking, updates, and schema migrations. Source: about 1 year ago

You can create the DAL using your existing code or start using a Object Relational Mapper like Entity Framework which will do a lot of the work for you, check this out here: https://learn.microsoft.com/en-us/ef/ also check out LINQ. Source: over 1 year ago

And, possibly (not strictly speaking necessary but very useful) Entity framework as a backend part of it. Source: over 1 year ago

For caps/num/scroll lock? Easy! I've used https://keyboard-leds.com before, which sits in the system tray, though I don't bother any more. Source: over 1 year ago

In the past, I've used a program to display the traditional keyboard key states, but in the end, I find it's just not necessary. Ideally, none of them should ever change and preventing them from being accidentally toggled is pretty easy. Source: over 1 year ago

Something like Windows https://keyboard-leds.com/. Source: almost 2 years ago

Windows: https://keyboard-leds.com/ Linux: It seems a lot of apps that give notification in the panel. Please Let me know if there's some big on screen popup similar to that app above which is only is visible when CAPS is active. Source: over 2 years ago