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...