Table variables Vs Temporary table

Table variables: It’s similar to local variable, they are used to hold small amount of data (around 500 rows) and available within the scope of the batch, stored procedure,  functions. Syntax for table variables:

The advantage of table variables over CTE is that they accessed during the entire batch or session.

Temporary tables: are […]

Read More

What Is Concurrency Control?

What Is Concurrency Control? Concurrency Control : ensures that modifications made by one person do not adversely affect modifications that others make. There are two type of concurrency control in DBMS. Pessimistic : Pessimistic concurrency control locks data when data is read in preparation for an update. Other users cannot then perform actions that would alter the underlying data […]

Read More

Model Binding in Asp.Net MVC

Model binding is an elegant bridge between the HTTP request and the C# methods that define our actions methods. Suppose someone requested for URL  “/Home/Index/1” which mean that filter the data by index 1 in controller method.

The process by which the URL segment was converted into the int method argument is an example […]

Read More

Creating MVC Custom Helper Methods

Inline Helper Method: We can create inline helper method using @helper tag.

and once helper has defined, we can easily use in body as follow. <div> Here are the fruits: @ListArrayItems(ViewBag.Fruits) </div>

Read More