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
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 create the first MVC application using .NET 6 and Visual Studio 2022. Also, we will see how .NET 6-based MVC project is different from than .NET Core-based MVC project. Prerequisites Create MVC application in .NET 6 Follow the below steps to create your first MVC application in Visual Studio 2022. … 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 Visual Studio 2022 The .NET 6 SDK which is automatically installed when you install Visual Studio 2022. Create First Console App Once you … 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