CRUD Operations using Generic Repository Wrapper in .NET Core Web API #core #repository #programming
https://youtu.be/jtUCaq3hNh8

subscribe as i am going t start zero to hero asp.net

Tutorials is started from now

will get everyday one video step by please subscribe channel thank you

join discord server i will reply on questions - https://discord.gg/V5st2sycsG

Need interview questions for dotnet to crack interview

2k only required

Connected Approach

Uses SqlConnection, SqlCommand, SqlDataReader
Works with ExecuteReader(), ExecuteNonQuery(), ExecuteScalar()
Keeps the database connection open while reading data
Disconnected Approach

Uses SqlConnection, SqlCommand, SqlDataAdapter, DataSet, DataTable
Works with Fill(), Update()
Loads data into memory and allows working offline

-Design Pattern => .
-Singleton Design Pattern => .
-SOLID principle  => .
-LSP Principle  => .
-Clean Code Principle =>
 
Candidate has solid experience in .Net Framework
-.Net Framework vs .Net Core => .
-Net Standard => .
-Providers and Options => .
-Dependency Injection  => .
-AddTransient vs AddScopped => .
-Logging => .
-Middleware => .
-Custom Middleware => .
-What is Request Delegates => .
-App.Use() & App.Run() => .
-Role of HostBuilder => .
-How to handle static files in dotnet core => .
 
 
Web API-
 
-Filters  => .
-Routing => .
-JWT =>
-Model Validation => .
-Custom Model Validation => .
-Cors => .
-Content Negotiation => .
-Api Versioning => .
-API doc and Testing =>  .
-RateLimit => .
 
 
C# =>
 
-Use case with C#(exception handling) => .
-Use case with C#(static constructor with static variable) => .
-Virtual => .
-Abstract => .
-Reference type and Value Types => .
-Garbage Collection => .
-Nullable Type => .
-Reflection => .
-Delegates => .
-Tuples => .
-Generic= >
-Static => .
-CLR => .
-Yield return => .
-try catch finally => .
-Anonymous Delegate => .
-String vs String Builder => .
-Covariance vs Contravariance => .
-IComparer<T> => .
-ObjectPooling => .
-Deep Copy vs Shallow Copy => .
-Async/Await => .
-Stream=> .
-Thread = > .
-TPL => .
-Multi-Threading => .
 
 
SQL =>
 
-Use Case with SQL(fix the name in pascal format) => .
-Use Case with SQL(Select Null Records) => r.
-Computed Column => .
-Cast vs Convert => .
-Magic tables => .
-Merge => .
-Coalesce => .
-IsNull => .
-Procedure vs View => .
-Transaction => .
-Truncate vs Delete => .
-Constraints => .
-Filtered Index => .
-Database Mirroring => .
-Union vs UnionAll => .
-GroupBy => .
-Join => .
-Pk vs Fk vs Candidate Key => .
-Functions => .
-Select Into => .
-While => .
-Scalar function => .
 
 
 
UNIT Testing =>
 
-Unit Framework => candidate using X-Unit.
-Mocking and Stubbing => .
-BDD Approach => .
-AAA principle => .
 
 
Entity Framework => .
-POCO classes => .
-Types of Entity State => .
-Complex Type => .
-Include Method => .
-How to use stored procedure => .
-How to Optimization and Performance => .
 
 
Javascript=> no exp
 
JavaScript modules? difference between CommonJS and ES6 modules.
concept of event bubbling and event capturing in JavaScript
Prototype inheritance in JavaScript
between == and === in JavaScript
closure in JavaScript
 
 
Angular =>
-Life Cycle hooks => .
-Constructor vs NgOnInit => .
-Entry Point => .
-Implement Spinner => .
-Impure Pipe vs Pure Pipe => .
-Interceptor => .
-Types of Form => .
-BehaviorSubject => .
-Directive => .
-Input & Output => .
 
Azure -
ARM -
Azure Resource Lock -
Scaling -
App Insight -
DataLake -
Key Vault -
Logic App -
Azure Function -
Azure Databricks -
Storage -

.net interview questions