Shekh Ali's Blog - Page 6 of 13 - A Blog About .NET Technologies

SOLID Design Principles in C#: A Complete Example

March 18, 2023January 19, 2023

Last updated on March 18th, 2023 at 04:30 am

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

SOLID Design Principles

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

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#

C# Partial Class And Partial Methods With Examples

January 3, 2023

C# Partial classes and partial methods will allow you to split the implementation of a class or a method across multiple files. This can be useful when working with automatically generated code, as it allows you to make changes to the generated code without losing them when the code is regenerated.

The partial keyword allows you to split the definition of a class, struct, interface, or method into multiple source(.cs) files. Each file contains a part of the definition, and all the parts are combined when the application is compiled.

This article will provide an overview of partial classes and partial methods in C#, including how and why they are implemented.

csharp-partial-class-and-methods — *C# Partial class*

C# Struct with [Examples]

February 14, 2023January 1, 2023

Last updated on February 14th, 2023 at 12:51 pm

C# Struct: A struct in C# is a value type that represents a lightweight object. It is similar to a class but stored on the stack rather than the heap. A struct is faster to create and use than a class. It is useful when you want to create small, lightweight objects to hold value-type data rather than a reference type.

It is also useful when you want to create mutable objects (that can be modified after they are created).

Structs have some limitations compared to classes. For example, structs cannot be inherited from other structs or classes. It also does not support some advanced features that classes support, such as virtual methods and polymorphism.

C# Hashtable vs Dictionary vs HashSet

January 1, 2023

A Hashtable, Dictionary, and HashSet are all data structures that store and retrieve data based on keys. However, there are some important differences between them.

csharp-hashtable-vs-dictionary-vs-hashset — *Difference-between-Hashtable, Dictionary-and-HashSet*

C# Hashtable with example – How to use and when to use?

December 29, 2022

In this blog post, we will take a deep dive into C# hashtables, explaining what they are, how they work, and how to use them effectively in our C# code.

We will also cover some common scenarios where hashtables can be particularly useful, as well as some tips and best practices for working with them. By the end of this post, you should have a solid understanding of hashtables and how to leverage their power in your C# projects.