Is there a great tutorial for learning C# desktop + DB?

Question

Database

Hello. I am a php developer myself. In my work I use Laravel, Yii. I am well acquainted with patterns and use them.
Recently, the task arose to write applications for windows, something like desktop.
The problem is that I have never written such applications. I've spent my entire programming life on the Web.
It is not a problem for me to learn the language and use it. I would like to understand how, from the point of view of architecture, it is most correct to do this, because not everything that is good on the web is suitable for the desktop.
Therefore, the question is whether there is a course, tutorial or book where a desktop application is created from scratch that interacts with the database.
It is a medium-sized application, not a type of calculator. It is desirable that there was work with wpf.

Answer 1

The best book for you would be Andrew Troelsen "The C# 6.0 Programming Language and the .NET 4.6 Platform".
A great book for professionals, covers everything about the language and almost every feature and use. First of all, it is intended for programmers who already know how to program, but do not know the C# language. It is structured into sections, each of which can be read independently and used as a reference.
This book has only one drawback - it is written for professionals, and the author writes how to do it, but does not write why to do it - you already understand this, otherwise the book would become quite gigantic.
I recommend taking the time and trying to write some console programs in c#, starting with my favorite quadratic solver :) and working with lists (a simple telephone directory). And only after that start working with WPF.
And here is a very decent tutorial on wpf:
https://professorweb.ru/my/WPF/base_WPF/level1/inf...
Quite dryly written, but with good examples.
And again, I recommend not starting to make your program, but using WPF to make the same programs that you wrote with the console. And learn MVVM.

Answer 2

some useful links
- https://www.techdays.ru/
- https://mva.microsoft.com/
- https://www.codewars.com/
ps I almost forgot - https://msdn.microsoft.com /ru-ru/

Answer 3

I highly recommend taking Qt. In addition to the convenience, having a great cross-platform development environment, you will get (with the right approach) a cross-platform application. There are a lot of documentation and how-to in different languages.

Answer 4

Map of specialties for the student
We go on .NET general, then on UI.
There are many lessons on youtube where projects are made in Rus / Eng languages ​​​​right from the database.

Answer 5

Practical acquaintance with databases on the example of creating the "Score Book" program - access sharing, user authorization, entering and displaying grades; use of the SQL language, MS Access database and MySQL.
Volume: 6 lessons
Database: MS Access, MySQL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LINK

Answer 6

In addition to books on the language - www.ozon.ru/context/detail/id/1616782/.
A must read for business application developers. The examples are written in Java, but this is not essential.