How to check if a column exists in a SQL Server table

By | June 11, 2018

How to check if a column exists in a SQL Server table, Syntax: IF EXISTS(SELECT 1 FROM sys.columns WHERE Name = N’columnName’ AND Object_ID = Object_ID(N’schemaName.tableName’)) BEGIN — Column is exists in DB END Example: Let’s Check wether address column is present in Employee table or not. IF EXISTS(SELECT 1 FROM sys.columns WHERE Name =… Read More »

Lazy Loading C#.Net

By | March 26, 2018

Some of the interviewer’s favourate question or we can say common interview question is What is Lazy Loading in C#.Net and when to use it  Lazy Loading in C#.Net Lazy loading is the concept in which we delay the loading of the object until the point where we need it. In simple terms loading the objects on… Read More »

Destination folder already exists in wordpress

By | March 17, 2018

How to fix destination folder already exists in wordpress for plugin This error ‘Destination folder already exists in wordpress’ usually comes while installing any plugin or theme. In this article, we will show you how to fix destination folder already exists error in WordPress. Reason for getting this Error: This error comes due to same folder… Read More »

When to use abstract class and when to use interface

By | January 1, 2018

When to use abstract class and when to use interface This question can be asked in many different ways, situation/scenario when to choose one over another. Abstract Class can be used in situation: When you want to declare feilds and assign default value to it, go for abstract class over interface. For E.g.: When i… Read More »

Inheritance in C# With Example

By | December 17, 2017

Inheritance in C# With Example? Let’s start with the concept Inheritance in C# with example, Inheritance is the concept in which one type (class/interface) derives data member and member functions from another type is called as inheritance. The type which derives the members from another type is called as derived type and the type from… Read More »