Get Connection String for Dapper and EFCore (Web or Console App) [Dotnet5] [2021]

Tutorial on how to retrieve your connection string from appsettings.json file in console apps, web apps, using Context or not using context, Entity Framework for dotnet5 (EFCore) OR Dapper (micro-orm) for SQL Server, and then use that connection string in each of these project types to actually query the database and get data out.