In this article, we will see 5 amazing extensions to use with Visual Studio 2022. As a developer, we want to do tasks efficiently and luckily we have helpful extensions available with Visual Studio 2022. There are numerous extensions available which can be used with Visual Studio 2022 and all the extensions have their own … Read more
This article focuses on “How to implement In-Memory Caching in ASP.NET Core?” What is Caching? Caching is a method to deliver data faster to the client so that information can be served a lot quicker for any future requests. So, we take the most often utilized information and duplicate it into brief capacity so it … Read more
In this article, we will learn about In-Process and Out-Of-Process hosting models in ASP.NET Core. At the point when you push your web application to IIS, different solicitations to the application are taken care of by what is known as ASP.NET Core Module. In-Process and Out-Of-Process Hosting Model Under default settings, the hosting model for … Read more
In this article, we will write code to read the request body in ASP.NET Core using custom Middleware. What is Middleware? Middleware in .NET Core is similar to HttpHandlers and HttpModules which were part of classic ASP.NET. When a user hit the request from a client such as a browser then before it hits the … Read more
Recently, I was involved in one of the migration projects. I had to migrate the existing ASP.NET Core 2.2-based project to .NET Core 3.1. I faced a few challenges and errors during the migration. However, one of the errors related to JSON took a lot of my effort. So I thought to post it here. … Read more
In this article, we will know about Tuple in C#. What is Tuple? Tuple is a lightweight data structure that may contain different data types. It is introduced in C# 7.0. Syntax to write Tuple Following code snippet is used to create a tuple with 4 elements of different data types. Create method of Tuple … Read more
In this article, we will see about deadlocks in SQL and how to trace and detect a deadlock with SQL Server Profiler. Let’s start with an introduction to Deadlock. What is Deadlock? Deadlock in SQL server is a scenario where two or more resources are trying to access the same resource which is mutually being … Read more
In this article, I will explain a scenario where the user has to remove duplicate records with different statuses. Scenario Consider below the table with 2 columns (Employee Name and Status) Now, write a query to fetch a unique Employee Name like this – If the Employee Name is unique then select it and if … Read more
In this article, we will create a CSV file from SQL Database using PowerShell script. Requirement Suppose there is a table in the SQL Server database and it contains more than 50,000 records. Now we want to create a CSV file and put all 50,000 records in this file and that should be an automatic … Read more
In this article, we will explore SignalR and also we will implement basic SignalR in ASP.Net Core 3.1. What is SignalR? SignalR refers to a real-time application communication channel. It is a process that allows the integration of real-time functionality into your web applications. In a real-time enabled process, the server sends data or content … Read more