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

URL vs URI: The Ultimate Guide to Understanding the difference between URL and URI

February 2, 2023

URL (Uniform Resource Locator) and URI (Uniform Resource Identifier) are both terms used to identify and locate resources on the internet. Despite being used interchangeably, there is a distinct difference between the two.
While a URL specifically provides the exact location of a resource on the internet, a URI can identify a resource in a broader sense and can include both its location (URL) and unique identifier (URN).
In this post, we will learn about the key differences between URL and URI and provides guidelines for choosing between them.

difference between url and uri — Difference between URL and URI

Understanding the Difference between == and Equals() Method in C#

February 1, 2023

In this post, we will be discussing a common confusion among C# developers: the difference between == and equals in C#. Whether you are a beginner or an experienced developer, understanding the difference between these two operators is crucial for writing efficient and accurate code.

In C#, the equality operator ‘==’ evaluates the equality of two operands, while the Object.Equals() method determines if two object instances are equal or not.

In this post, we will cover the purpose, usage, speed, and flexibility of ‘==’ and ‘.Equals()’, as well as some frequently asked questions. So, let’s get started!

difference-between-equality-operator-vs-equals-method-in-csharp — Difference between equality operator ‘==’ vs equals method in C#

Difference between SortedList and SortedDictionary in C#

January 31, 2023

In this post, We will learn about the SortedList and SortedDictionary in C# using some code examples. Furthermore, we will compare these two collections in a tabular format which will help us to understand the fundamental difference between SortedList and SortedDictionary in C#.
By the end of this post, you should have a good understanding of when to use SortedList and when to use SortedDictionary in your code.

difference-between-sortedlist-and-sorteddictionary-in-c-sharp — Difference between SortedList and SortedDictionary in C#

Understanding the Difference between int, Int16, Int32, and Int64 in C#

September 29, 2023January 30, 2023

Last updated on September 29th, 2023 at 12:57 pm

C# provides several data types to store numerical values and it’s important to choose the right one. In this article, we will delve into the difference between int, Int16, Int32, and Int64 in C#. You will learn about the size, minimum, and maximum values for each data type and when it is appropriate to use them.

In C#, int, Int32, and Int64 are numeric data types capable of storing integer values. They differ in their range and memory usage.

The main difference between int, Int16, Int32, and Int64 in C# are as follows:
Int16 variables can hold values ranging from -32,768 to 32,767,
Int32 variables can hold values ranging from -2,147,483,648 to 2,147,483,647 and
Int64 variables can store values ranging from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.

difference-between-int-int16-int32-and-int64 — difference between int int16 int32 and int64

Jump Statements in C# (Break, Continue, Goto, Return and Throw)

January 29, 2023January 29, 2023

Jump statements allow you to control the flow of your program. They are also known as control transfer statements. There are several types of jump statements in C#, including break, continue, goto, return, and throw.
In this post, we will try to learn different types of jump statements available in C# with multiple examples. Additionally, we will discuss how and where to use them.

jump-statements-in-c-sharp — jump statements in C#

Is vs As operator in C#: Understanding the differences between is and as operator in C#

March 1, 2023January 28, 2023

Last updated on March 1st, 2023 at 11:01 am

is vs as operator in c#:

In C#, the IS and AS operators are essential keywords used to determine the type of an object during runtime.
The IS operator checks the type of an object and returns a boolean value, which is true if the object is of the same type and false if not. On the other hand, the AS operator not only checks the type of an object but also performs a type conversion if the object is compatible with the given type.

is-vs-as-operators-in-csharp — is vs as operators in csharp

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

Difference Between UNION and UNION ALL in SQL

July 9, 2023January 25, 2023

Last updated on July 9th, 2023 at 07:11 am

When comparing UNION with UNION ALL, there is a significant difference:

UNION returns only unique records, while UNION ALL returns all records, including duplicates.
UNION performs additional processing to identify and eliminate duplicate rows, which can make it slower compared to UNION ALL.

In this article, we will look at the differences between UNION and UNION ALL in SQL with multiple examples.

UNION-VS-UNION-ALL-IN-SQL-SERVER

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

February 22, 2023January 23, 2023

Last updated on February 22nd, 2023 at 06:38 pm

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. This blog post 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

December 30, 2023January 22, 2023

Last updated on December 30th, 2023 at 10:06 pm

In this article, We will explore the Singleton design pattern in C#, its use cases, and various ways to implement singleton class.

Singleton-Design-Pattern-in-CSharp — Singleton Design Pattern in C#

SOLID Design Principles in C#: A Complete Example

September 1, 2023January 19, 2023

Last updated on September 1st, 2023 at 07:53 pm

SOLID is a set of five design principles introduced by Robert C. Martin in 2000 to make code more maintainable, flexible, and scalable.

In this article, we will learn about five important SOLID principles and how they can be used with C# programming. We’ll also see practical examples to understand how to apply these principles in real-world situations.

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.

SOLID-Design-principles — SOLID Design Principles

Delete vs Truncate vs Drop in SQL Server (2023)

November 1, 2023January 14, 2023

Last updated on November 1st, 2023 at 04:36 pm

What is the Difference between Delete, Truncate, and Drop command?

The “DELETE” command removes one or more records from a table in the database, and the “TRUNCATE” command removes all rows from a table, but Still, it keeps the table structure, and the “DROP” command completely removes the entire table from the database.

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

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

July 8, 2023January 10, 2023

Last updated on July 8th, 2023 at 03:18 pm

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 main difference between the WHERE and HAVING clauses in SQL is that the WHERE clause filters individual rows before grouping, while the HAVING clause filters groups of rows after grouping based on aggregate conditions such as MIN, MAX, SUM, AVG, COUNT, and so on.

In simple terms, WHERE is for filtering rows, and HAVING is for filtering groups.
Additionally, it is important to note that aggregate functions can be used with the HAVING clause but not with the WHERE clause.

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

having-vs-where-clause-in-sql — having-vs-where-clause-in-sql

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

March 23, 2024January 9, 2023

Last updated on March 23rd, 2024 at 01:09 pm

Dispose() and Finalize() are crucial methods for releasing resources in C#. These methods are used to clean up resources, such as database connections and files that are no longer needed. However, there are some significant differences between the dispose and finalize methods in C#.

The IDisposable interface defines the Dispose() method, while the Object class defines the Finalize() method.
Users can explicitly call the Dispose() method, whereas the Finalize() method is automatically called by the garbage collector (GC) 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.

sql-pivot-tables — SQL pivot tables

Web services vs API: Top 10+ difference between API and Web Service

July 23, 2023January 6, 2023

Last updated on July 23rd, 2023 at 11:51 pm

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 have some key differences, so we need to know them before incorporating them into our project.

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

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]

August 2, 2023January 1, 2023

Last updated on August 2nd, 2023 at 04:53 pm

CSharp-Struct — C# Struct

A C# Struct is a value type that represents a lightweight object. Unlike classes, which are stored on the heap, a struct is stored on the stack, making it more memory-efficient and faster to create and use.

Struct is a perfect choice for creating small, lightweight objects that hold value-type data and do not require inheritance.

C# Hashtable vs Dictionary vs HashSet

March 27, 2023January 1, 2023

Last updated on March 27th, 2023 at 10:31 pm

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.

csharp-hashtable-class