Questions Links

https://career.guru99.com/top-50-asp-net-web-api-interview-questions-and-answers/

https://dotnettutorials.net/lesson/web-api-interview-questions/

https://www.dotnettricks.com/learn/webapi/top-20-web-api-interview-questions-answers

https://www.codeproject.com/Articles/769140/Top-ASP-NET-Web-API-Interview-Questions


MVC

https://www.codeproject.com/Articles/769140/Top-ASP-NET-Web-API-Interview-Questions

SOLID Principle in Programming

This principle is an acronym of the five principles which is given below…

1. Single Responsibility Principle (SRP)
2. Open/Closed Principle
3. Liskov’s Substitution Principle (LSP)
4. Interface Segregation Principle (ISP)
5. Dependency Inversion Principle (DIP)

Read more here >

 

https://www.geeksforgeeks.org/solid-principle-in-programming-understand-with-real-life-examples/

how to get the count of columns of tables in sql

Get the number of columns in the table

Use [yourdatabaseName]

SELECT COUNT(*)
FROM information_schema.columns
WHERE table_name = 'yourtableName'

OR

SELECT COUNT(*)
FROM yourdatabaseName.sys.columns
WHERE object_id = OBJECT_ID('yourdatabaseName.dbo.yourtableName')