C# CONCEPTS

Use Case

Lets us take an example of a Car, and the user wanted to build two models, i.e., SUV and Sedan.

Builder design pattern comes in handy in the above use case, and let's see a step-by-step demonstration.

And the Car class has the following properties.

public class Car{
 public string Name { get; set; }
 public double TopSpeed { get; set; }
 public bool IsSUV { get; set; }
}

Prerequisites

• Basic knowledge of OOPS concepts.
• Any programming language knowledge.

The article demonstrates the usage of builder design patterns using the C# programming language. So, to begin with, C#

Learning Objectives

• How to…

.NET CODE ANALYSIS

The article describes how to analyze C# code quality using the SonarQube command line.

Prerequisites

1. Download the SonarQube free Community Edition
2. SonarQube scanners require version 8/11 of the JVM, and the SonarQube requires version 11
3. Install PostgreSQL for demonstration, but it also supports MSSQL and Oracle databases.
4. For the .Net Core 2+ version, download SonarQube Scanner.
5. For the .Net Framework version, download SonarQube Scanner.

Getting Started

Following steps to configure & run C# code analysis using SonarQube for .Net Core applications.

Unzip folders(prerequisites in points 1 and 4) into a directory.

Configure User

Follow the below commands to configure a database & user in the…

C# CONCEPTS

The mediator design pattern helps us design loosely coupled applications by encapsulating object interactions.

Use Case

Let’s consider an example of a chatroom where participants register, how to communicate efficiently.

Need to implement following chatroom conversation using the Mediator Design Pattern.

David to Scott: 'Hey'
Scott to David: 'I am good how about you.'
Jennifer to Ashley: 'Hey ashley... david is back in the group'
Jennifer to David: 'Where have you been?'
Ashley to David: 'How come you aren't active here anymore?'

Prerequisites

• Basic knowledge of OOPS concepts.
• Any programming language knowledge.

The article demonstrates the usage of mediator design patterns using the…

C# CONCEPTS

Learning Objective

• How to create generic interfaces of type T
• How to implements a generic interface in a non-generic class
• How to implements a generic interface in a generic class

Prerequisites

Please go through the basic concepts of generics for a better understanding of the article.

Getting Started

Let us understand how to create an interface of type T. A blank interface will look like this.

public interface ITest<T> { }

An interface with one member function definition

public interface ITest<T> {
   List<T> GetList();
}

The syntax for multiple generic values for an interface

public interface ITest<T, U>{
  List<T> GetList(U value);
}

After understanding the…

C# CONCEPTS

In other words, the adapter design pattern helps incompatible interfaces work collectively.

Use Case

Let's consider an example of two organizations merging; X organization is taking over Y, but while combining code, the interfaces are not compatible. Assume that interface that provides a list of transactions of organization Y is not compatible with X.

So the adapter design pattern helps solve this problem whose implementation is very straightforward.

Prerequisites

• Basic knowledge of OOPS concepts.
• Any programming language knowledge.

The article demonstrates the usage of adapter design patterns using the C# programming language. So, to begin with, C#

Learning Objectives

• How to code using an adapter…

MSSQL

Any applications getting connection timeouts to MS-SQL Server will see the following error.

Message=Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and the max pool size was reached.

Most of the time, this failure happens due to connection leaks in the application. Run the following query to check the list of connection requests in the MSSQL Server:

select count(1) conection_count, program_name, host_name, status, host_process_id from sys.dm_exec_sessions where is_user_process = 1 group by program_name, host_name, status, host_process_id order by 1 desc

The connection requests…

C# CONCEPTS

In other words, a change in one object initiates the notification in another object.

Use Case

Let’s take an example of an Instagram celebrity influence who has “x” number of followers. So the moment the celebrity adds a post, then all the followers are notified.

Let us implement the aforementioned use case using Observer Design Pattern.

Prerequisites

• Basic knowledge of OOPS concepts.
• Any programming language knowledge.

The article demonstrates the usage of observer design patterns using the C# programming language. So, to begin with, C#

Learning Objectives

• How to code using an observer design pattern?

Getting Started

According to the use case, the first implement an interface…

VISUAL STUDIO TIPS

Tip 1: Box Selection

Let’s take an example of the following class with integer properties and apply box selection to update int to, let's say, double at one shot.

public class Test {
 int x = 10;
 int y = 20;
 int z = 30;
 int l = 40;
}

Shortcut Key: “Shift + Alt + down arrow (to select multiple rows).”

So the box selection works with all types of file extensions like “.cs” or “.html,” etc., in Visual Studio.

Example: “.html” file