By Sandeep Shrestha

https://www.facebook.com/Sonseldeep https://www.instagram.com/sonseldeep/ https://github.com/Sonseldeep https://www.youtube.com/@sonseldeep https://www.linkedin.com/in/sonseldeep/

<aside> ✍🏼

Learn VS Code OR Rider Or Visual Studio for C# before learning C#

VS Code : Resources

Visual Studio : https://www.youtube.com/watch?v=_n45-ikM420

Install SQL Server on Linux : https://www.youtube.com/watch?v=T3sXphWAPOs

</aside>

<aside> ✍🏼

if you are using Linux : Docker

install SQL server using Docker

installer docker on linux (ubuntu) my one

https://docs.docker.com/engine/install/ubuntu/

Just do copy paste exercise

Verify Docker Installation : Terminal

docker run hello-world

docker ps

docker ps -a

After installing Docker : Time to run SQL SERVER

docker run --restart unless-stopped -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=yourPassword" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest

Details : Summary of SQL SERVER DOCKER

https://docs.google.com/document/d/17rrVqudVtTpaoVaIjqhrmIv7Ro0-OQtq30-9CqEVSYE/edit?usp=sharing

</aside>

<aside> ✍🏼

Connection String

past this into appsettings.json

Connection String

</aside>

<aside> ✍🏼

Alternative to SSMS

Cross platform tools

in linux there is no SSMS but there exists alternative

Azure Data Studio not so good but Ok

https://learn.microsoft.com/en-us/azure-data-studio/download-azure-data-studio?tabs=win-install%2Cwin-user-install%2Credhat-install%2Cwindows-uninstall%2Credhat-uninstall

Beekeeper Studio (open source ) recommendation

https://www.beekeeperstudio.io/

</aside>

<aside> ✍🏼

Basic C#

Learn C#

Basic to Professional Level C#

</aside>

<aside> ✍🏼

Database:

https://www.youtube.com/watch?v=1RCMYG8RUSE

</aside>

<aside> ✍🏼

Web API: The god for beginner level

if you want to save your month spending on finding best course for beginner level this this is best for you Based on my experience

from database concept to folder structure

Ef core

must once one if you are beginner

https://www.youtube.com/watch?v=oOUSvRc3FMo&list=PL82C6-O4XrHdiS10BLh23x71ve9mQCln0&index=4

if you are watching this above videos this https://drive.google.com/file/d/1EbYYjY7ubkpVKgBVE3Dloa9tr-oqo58g/view

you must see that UML Diagram, and you will fing how , why and so it is.

Repo: https://github.com/teddysmithdev/pokemon-review-api

https://www.youtube.com/watch?v=qBTe6uHJS_Y&list=PL82C6-O4XrHfrGOCPmKmwTO7M0avXyQKc

</aside>

<aside> ✍🏼

ASP.NET CORE For Begineers

Resources

Resources_2

Resources_3

https://www.youtube.com/watch?v=AKjG2tjI07U&list=PLF1jhYUTnHo7Jvmf-xzefwLaT10Xp1U8C

</aside>

YouTube Channels for .NET Learning

Channel Name Focus Areas Skill Level URL
Microsoft Developer .NET, C#, ASP.NET Core, Blazor Beginner to Advanced Microsoft Developer
Nick Chapsas C#, .NET Core, Performance Intermediate to Advanced Nick Chapsas
Kudvenkat ASP.NET, MVC, Entity Framework Beginner Pragim Tech

ASP.NET Core Learning Roadmap

Week 1: Basic C#

<aside>

C# Fundamentals

<aside>

Object-Oriented Programming

</aside>

<aside>

</aside>

Reference Books:

[EXPERT INSIGHT] Mark J. Price - C_ 13 and .NET 9 – Modern Cross-Platform Development Fundamentals,9th Edition (Final Release) (2024, Packt Publishing) - libgen.li.pdf

Csharp 8.0 and .NET Core 3.0 – Modern Cross-Platform Development 4th Edition.pdf

Learn ASP.NET Core 3.pdf