Category: Design and Architecture

Nov 16

Sorting, Filtering, Searching and Pagination using SQL Stored Procedure

Application performance is one of the important aspect in any kind of software application. This non functional requirement (NFR)  developers forget while implementing (this in generally I observed while doing code reviews) table or grid design . Developers generally try to fetch all the records from database and displays using third party grids or open …

Continue reading »

May 02

Generic Data Access Layer in C# using Factory Pattern

Generic Data Access Layer in C# using Factory Pattern 1.   Introduction A data access layer is an important part of any software application. Typically, a large enterprise(N-Tier) application will have one or more databases to store the data. On the top of these databases the Data Access Layer(DAL) is created. A business layer which contains …

Continue reading »

Jul 13

How to create SQL Deployment Script

How to create SQL Deployment Script 1.  Introduction Deployment is one of the important aspect in software industry. Developers  generally face lots of script execution failure issues on Quality Assurance(QA), User Acceptance Test(UAT) and Production server(PROD). These script execution failure issues occur due to improper preparation of deployment script. In this article, I am going …

Continue reading »

Nov 15

C# Coding standards and Best Practices

In this post i am describing the rule and recommendations for developing software application and class libraries in .NET using C# as a language. The main purpose is to define the general guidelines to enforce consistent coding styles and formatting that can be useful for developers to avoid common mistakes they do while development of …

Continue reading »