Implementing Windows Authentication in .NET Core Web API (short guide with examples)

Use case: We need to implement simple Windows authentication for an intranet ASP.NET CORE WEB API application which should authorize users by verifying user details in a custom database. What is Windo