Let's Create a Web API with .NET 8 (& Dapper) PART 1: 📚The Book Feed📚

NOTE: Use this command for creating a Web API: dotnet new webapi --use-controllers
Disclaimer: If you "just" use dotnet new webpi without --use-controllers in newer versions, you will not get controllers!

Part 1 of making a full-stack application with .NET & Angular, in which we create the backend portion of a book feed.

Recommended prerequisites:
- Basic knowledge about relational databases (SQL)
- Basic knowledge about object-oriented programming (any language)
- Basic skills for navigating your file system & command line interfaces (Bash recommended)

Timestamps:
00:00:00 Introduction & Installations
00:03:00 The .NET WebAPI template
00:06:20 Explaining the files
00:11:34 Changing an endpoint
00:17:42 ElephantSQL (Postgres)
00:21:04 Creating layered structure
00:27:18 Environment variables
00:30:10 Nuget packages
00.32:50 SQL query with Dapper
00:43:20 Dependency injection
00:47:25 .sql file for library_app schema
00:50:50 Enabling CORS
00:51:30 Swagger / OpenAPI
00:54:35 Wrapping up & next video

Next video in this series: Full CRUD!

[fantodk]

No rest for the wicked, nice video Alex ! o/

[jurijowsienko]

12:39 So called 'primitives' are value objects not objects (they do not inherit from 'Object'), returning 1 as an object causes wraping '1' into System.Object (also know as boxing), which is implicit and causes an allocation on the heap.

[Tadiaki]

Well, look who decided to grace us with another masterpiece. I was starting to lose hope.