- how to make authentication and authorization using asp.net core MVC
https://learn.microsoft.com/en-us/aspnet/core/security/authentication/identity?view=aspnetcore-8.0&tabs=visual-studio
- State management in asp.net core MVC
https://learn.microsoft.com/en-us/aspnet/core/fundamentals/app-state?view=aspnetcore-8.0
3 what i have to use to call sql server ado.net or dapper or EF which one is best.
You asked the same question in a previous thread. Rather than duplicating your questions, can you tell us specifically what you are still struggling to understand?
Entity Framework is a complete object-relational mapper (ORM) and unit-of-work. You get to interact with a database using C# objects.
https://learn.microsoft.com/en-us/aspnet/entity-framework
Dapper is a lightweight ORM that lets you write your own queries and maps the results to an object. If you take a few hours to paly with EF and Dapper you're get the idea pretty quickly.
- I have to use any design pattern. if yes give any example
The ASP.NET Core fundamentals documentation covers the official programming patterns that are found in ASP.NET Core. Dependency inject is a main concept in ASP.NET Core and one that you'll use when creating services. The factory and singleton patterns are common in ASP.NET Core and also covered the official documentation. MVC and Razor Pages are themselves programming patterns and EF is a unit of work pattern.
https://learn.microsoft.com/en-us/aspnet/core/fundamentals/dependency-injection?view=aspnetcore-8.0
As stated above there are many design patterns to choose from other than the patterns common to ASP.NET Core. Each design pattern solves common programming problem. If you can give us a programming problem that you are trying to solve, then we can point you to a design pattern. Otherwise, take some time to learn design patterns.
https://www.dofactory.com/net/design-patterns