Skip to main content

Recently Updated Pages

ViewModel

Go To Naming Conventions For information regarding view models, click the images below The ...

Attributes

Go To Naming Conventions The ASP.NET MVC framework supports four different types of filters exec...

Model/ Domain Model

Go To Naming Conventions For information regarding models, click the images below Contain p...

Naming Conventions

The following naming convention must be followed when creating any of the MVC pattern sections. A...

General

For a general guide on ASP.NET MVC, click on the following image Each functional domain being ...

Routing

Go To Naming Conventions For a guide regarding routing, click on the image below Area specifi...

Table of contents

1. General 2. Naming Conventions 3. Models / Domain Models 4. View Models 5. View 6. Control...

Cursors

Use cursors only when absolutely necessary. If the function performed by the cursor could have...

Common table expressions (CTE's)

CTE table names are declared with the prefix cte Used to simplify complex joins and subqueries...

Temporary tables

Temp tables are used for the large temporary storage of data. Only use local temp tables.  Us...

Table variables

Use table variables over temp tables for a small quantity of data (thousands of bytes) https...

Tables and indexes

Always use a column list in INSERT statements of SQL queries. This will avoid a problem when ta...

User defined functions

Do not call functions repeatedly in stored procedures, triggers, functions and batches, instead...

Stored procedures

EXCEPT or NOT EXIST clause can be used in place of LEFT JOIN or NOT IN for better performance (...

Triggers

Limit the use of triggers only for auditing, custom tasks, and validations that cannot be perfo...

Views

Incorporate your frequently required, complicated joins and calculations into a view so that yo...

jQuery

Prefix jQuery object variables with a $. // bad const sidebar = $('.sidebar'); // good ...

TypeScript

Design Principles and Standards

For design principles using React, use the guide below by clicking the image For styling using...

Iterators (Loops)

Don’t use iterators. Prefer JavaScript’s higher-order functions instead of loops like for-in or...