Application Stuck on Loading in Visual Studio
Clear browser cache
Author: sumit
SQL Server
Heap
What is a SQL Server Heap? Before we get into the different types of indexes that are available in SQL Server we should first describe the basic structure of a table. Tables with no clustered…
SQL Server
Stored Procedures
Stored procedures are basically a list of sql statement that needs to be executed. it works a function in our programming languages. Like you create a function and call it when ever you want. So…
SQL Server
Triggers
Triggers are specail stored procedures that execute automatically based on an event. There are 3 types of triggers: DML (Data-Manipulating Language) Triggers: work when the event of DMLs are invoked like Insertion, Updating, Deletion etc…
Others SQL Server
Indexes
Index basically is a way to find the relevant data row faster. so sql provides us the features of using indexes. There are two types of indexes basically: Clustered Index: A clustered index is one…
SQL Server
Views
where ever we use a select statement we get some kind of resultset. in order to save our time sql provides a functionality to save such queries as views so Views are basically stored queries.…
.Net Core .Net MVC C# Interview Questions
WEB API INTERVIEW QUESTIONS
1. What is ASP.NET Web API? ASP.NET Web API is a framework provided by the Microsoft with which we can easily build HTTP services that can reach a broad of clients, including browsers, mobile, IoT…
.Net Asp.Net MVC C# Development
Consuming API and WebClient vs. HttpClient vs. HttpWebRequest
In a nutshell, WebRequest—in its HTTP-specific implementation, HttpWebRequest—represents the original way to consume HTTP requests in .NET Framework. WebClient provides a simple but limited wrapper around HttpWebRequest. And HttpClient is the new and improved way…