Why ASP.NET MVC framework

MVC framework provides a lot of benefits for web development. The main objectives of the framework are: 1. Separation of Concerns:  MVC provides a clean, organized and efficient organization of code. It is very helpful for a web application to scale in terms of functionalities and also promotes good design pattern. 2. URL Routing Mechanism: […]

Read More

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

Validations in Asp.net MVC

  Data Annotations help us to validate any properties in the model in Asp.net MVC. Data annotations are nothing but attributes which can be applied on model properties. For example, in the below code snippet we have a simple Employee class with a property EmployeeCode. This EmployeeCode property is tagged with a Required data annotation attribute. Which mean EmployeeCode is […]

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