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 learn the concept of SignalR and also we will implement basic SignalR in .Net Core. Real-time communication is one of the crucial features in the modern tech world, this means allowing users to exchange information without using any page refresh. That’s what the SignalR does. What is SignalR? SignalR refers … Read more
Hello friends, in this article I will write about How to upgrade from ASP.NET Core 3.1 to .NET 6.0. To demonstrate this, I have developed a basic CRUD application in .NET Core 3.1 using Visual Studio 2022. Pre-requisites To upgrade from ASP.NET Core 3.1 to .NET 6, you should have the below tools, SDK, IDE … Read more
In this article, we will demonstrate How to build the first MVC application in Visual Studio 2022 using .NET 6. Also, we will see how the .NET 6-based MVC project is different from than .NET Core-based MVC project. Prerequisites Create MVC application in Visual Studio 2022 Follow the below steps to create your first MVC … Read more
This article shows how to create and run a .NET console application in Visual Studio 2022. You may read one of the earlier articles – What’s new in Visual Studio 2022? Prerequisites Create First Console App Once you have installed all the prerequisites then follow the below step to create your first console application in … Read more
In this article, I will write down the process which I used to Migrate from ASP.NET Core 2.2 project to .NET Core 3.1. Read my previous articles which are related to the migration process – .NET Core 3.1 API returns empty JSON objects How to check the C# version in Visual Studio 2022? My Current … Read more
I faced one strange issue during the migration process of .NET Core 2.2 to .NET Core 3.1. All the steps as per Microsoft was done and the API runs successfully in .NET Core 3.1. I feel very excited, but when I tested and looked at the output then I was shocked. There were neither compile-time … Read more
In this article, we will learn how to check the C# version in Visual Studio 2022. However, this solution will work with all versions of Visual Studio. Recently, I came across a real-time project in which I had to migrate the .Net Core older version application to .NET Core 3.1. In another blog, the Migration … Read more
