Generation Gap

Job Profile  .NET Developer (Remote Job) Questions Start with your introduction. Total years of experience in .NET Technology. Any experience in Angular? How to convert the existing ASP.NET project to the .NET Core Web? Web API structure? Any idea about PATCH? What are the attributes used with WebAPI for eg. Authorize, Route and so on. What type of project you working and it's architecture? About multi-level architecture, client server and other architecture. Stored Procedure vs Functions Store proc returns the data set. CTE vs Joins vs Sub query - which one is faster? Joins is faster then CTE then sub query. What are the types of joins? Which joins we need to use first when they are used together?  Inner join is used first because it filters out the matched one. Entity Framework vs Dapper vs ADO.NET In EF, which approach one is best Code-First, Database First and Model First? Authentication and Authorization using Web API? Have you worked on any of the CLOUD - AWS, Azure? Have you