How to start writing CLR for MS SQL Server in c# in MVS2022?

Question

C++ / C#

How to start writing CLR for MS SQL Server in c# in MVS2022?

Problem:
1. I want to find information "for a teapot" on C # with examples
2. I want to learn how to work in MVS-2019/2022
3. I want to learn how to work with GitHUB in MVS-2019/2022 (starting from MVS-2017, working with github is built into studio)
4. I want to learn how to properly deploy CLR in MS SQL Server 2019 and newer.

What does NOT work:
1. After MVS-2015 (it seems) CLR cannot be built from the main menu. I'm doing it from solutionExplorer - but isn't that right?
2. Most of the C# code for me is "Chinese writing". Especially - syntactic sugar, be it wrong! I can copy-paste and redraw someone else's with Google and MSDN, but I can't "give birth to my own" :(
3. On the Microsoft site, the CLR manual for MS SQL is written using an example for C ++, or with manual compilation of a text file for .net. And about MVS there "does not smell" at all ...
4. There is an article on Habré how to debug the CLR - but this is all from 2013.
5. Cherry on the cake - with MSSQL-2017, the accembly deployment process to the database has changed - all books WRITTEN before 2019 are useless, IMHO. To write to Microsoft, you need to understand well what is at stake (I don’t have this), and wait a long time.
6. Videos either show how to write HelloKitty, or how the code interpreter works for C#, F#...
7. There are a lot of words in books and articles about inheritance classes and delegates, which are generally not needed for scull builds. There is Richter (edition 4), but this is 2013 - a lot of changes have passed in 10 years ...

Therefore, the question is: what to read (from the newest) or watch (from the latest)? At the same time, books on C # for Unity are unlikely to help me ... And this, look - in Russian, preferably ...

PS There are projects partially made in C # - and they somehow (exactly that somehow) work. There is MVS. There is GitHUB. But there is no understanding. I feel like a baboon hammering screws into roof tiles with a nuclear baton. Sometimes it even works out.

Answer 1

Read - of the docks.
Only in practice. Take a project, do it and learn. There are no books