Shekh Ali's Blog - A Blog About .NET Technologies

SOLID Design Principles in C#: A Complete Example

January 25, 2023January 19, 2023

Last updated on January 25th, 2023 at 12:15 am

SOLID is a set of five design principles introduced by Robert C. Martin in the year 2000 to make code more maintainable, flexible, and scalable. In this article, we will explore each of these principles and how they can be applied when using C#. We will also learn a real-world example to show how these principles can be implemented.

SOLID Design Principles

SOLID is a widely recognized acronym that represents a set of five fundamental design principles in software development, namely the Single Responsibility Principle, Open-Closed Principle, Liskov Substitution Principle, Interface Segregation Principle, and Dependency Inversion Principle.

Different ways to delete duplicate rows in SQL Server

January 27, 2023

Duplicate data can cause a number of issues when working with SQL Server tables. Not only does it take up unnecessary space, but it can also lead to confusion and errors in reporting. In this blog post, we will explore several different ways to delete duplicate rows in SQL Server.

delete-duplicate-rows-in-sql-server-table

UNION vs UNION ALL in SQL SERVER: A Comparative Analysis of Differences and Uses

January 25, 2023

Union vs Union All: The UNION and UNION ALL operators are most commonly used to retrieve records from multiple tables into a single result set.

UNION returns distinct records from both tables, while UNION ALL returns all the records from both tables including duplicates.
In this article, we will look at the differences between UNION and UNION ALL. So before making a comparison, let’s briefly discuss these operators.

Abstract Factory Design Pattern in C#: Real-World Example and Code Explanations

January 23, 2023

The Abstract Factory Design Pattern is a creational design pattern that provides a way to create families of related or dependent objects without specifying their concrete classes. In this blog post, we will explore the Abstract Factory Design Pattern in C#, using a real-world example and providing code explanations.

Abstract-Factory-Design-Pattern-in-CSharp

Singleton Design Pattern in C#: A Beginner’s Guide with Examples

January 24, 2023January 22, 2023

Last updated on January 24th, 2023 at 02:49 am

The Singleton design pattern is one of the most widely used design patterns in software development. It is a creational pattern that ensures a class has only one instance while providing a global access point to this instance. In this blog post, we will explore the Singleton design pattern in C#, its use cases, and various ways to implement it.

Singleton-Design-Pattern-in-CSharp — *Singleton Design Pattern*

Delete vs Truncate vs Drop in SQL Server: What is the Difference between DELETE, TRUNCATE and DROP in SQL?

January 14, 2023

In SQL Server, the Delete, Truncate and Drop commands are used to delete or remove data from a table. Despite the fact that these commands are often used interchangeably, they have distinct implications and consequences. We will look at the differences between delete, truncate, and drop commands and how to use them correctly In this article.

delete-vs-truncate-vs-drop-command-in-sql — *Delete vs Truncate vs Drop command in SQL*

Difference between DELETE, TRUNCATE, and DROP commands

Having VS Where Clause in SQL | Explore the main Differences between Where and Having Clause in SQL

January 14, 2023January 10, 2023

Last updated on January 14th, 2023 at 03:43 am

What is the difference between the HAVING and WHERE clause? This is one of the most frequently asked questions in interviews, particularly among freshers.
The HAVING and WHERE clauses in SQL Server are very similar purposes, but they operate at different stages of the query and have some key differences.

The main difference between these two clauses is how they are used with the GROUP BY clause. The HAVING clause is used with GROUP BY, while WHERE is not.
In simple words, the WHERE clause is used to filter records before any groupings are made, while the HAVING clause is used to filter values from a group.

Let’s first understand what these clauses are used for in SQL.

C# dispose vs finalize – Understanding the difference between dispose and finalize in C#

January 9, 2023January 9, 2023

Dispose() and finalize() are two important methods used for releasing resources in C#. These methods are used for cleaning up resources like database connections and files if they are no longer required. but there are some significant differences between the dispose and finalize methods in C#.

In C#, Dispose() and Finalize() are methods that are used to release unmanaged resources held by an object. The Dispose() method is defined in the IDisposable interface, whereas the Finalize() method is defined in the Object class. The Dispose() method can be called explicitly by the user, whereas Finalize() method is automatically called by the GC (garbage collector) before an object is destroyed.

Dispose-vs-finalize — *Dispose() vs finalize*()

SQL pivot tables: Understanding pivot tables in SQL Server

January 14, 2023January 7, 2023

Last updated on January 14th, 2023 at 03:19 am

SQL pivot tables are a powerful and convenient way to summarize and analyze large data or records. They allow you to rearrange rows and columns in a dataset, group data together, and perform calculations on the grouped data.

In this article, We will try to learn what pivot tables are and how to use them in SQL.

Web API vs web service: Top 10+ Differences between web API and web service in C#

January 15, 2023January 6, 2023

Last updated on January 15th, 2023 at 04:14 am

Web API vs web service: A Web API & Web service are ways for two machines to communicate with each other over a network. They both allow for information to be exchanged between a client and a server.

An API or web service hosted on a machine can receive requests from other devices(such as smartphones, computers, and tablets,) over a network and sends back the requested resources, which can be in various formats like XML, JSON, HTML, images, audio files, etc.

Web APIs and web services look similar but they have some key differences, so it’s important for us to know them before incorporating them into our project.

web-api-vs-web-services — *Web API vs Web Services*

Key Differences Between Web API and Web Service in C#