sharepointcafe
How do you remove duplicate records with different status in SQL Server?
.
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…
PowerShell script to create CSV file from SQL Table
.
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…
How to implement SignalR in .NET Core?
.
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…
How to upgrade from ASP.NET Core 3.1 to .NET 6.0?
.
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…
Build Your First MVC Application in Visual Studio 2022
.
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…
Create First Console App in Visual Studio 2022
.
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…
How to Migrate from ASP.NET Core 2.2 project to .NET Core 3.1?
.
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…
.NET Core 3.1 API returns empty JSON objects – Solved
.
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…
How to Check C# Version in Visual Studio?
.
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…
High salary paying programming languages in 2021-2022
.
Software Programmers and Developers are among the highest-paid professionals around the globe. For Programmers and Developers, the programming languages they use are the core of their work. They earn six-figure annual salary packages in major countries like the USA, Canada, UK, Germany, India, Australia, Denmark, Japan and China. We have compiled this article for you…
What is Google AI and how to use it positively?
.
You must know about Artificial Intelligence. Artificial intelligence is sometimes called machine intelligence in the field of computer science. It is intelligence, in contrast to the natural intelligence displayed by humans and animals. In this post, you will get complete information about Google AI. So let’s know what is Google AI and how to use…
Exploring the Enhanced Performance and Productivity in Visual Studio 2022
.
Visual Studio 2022 has now been officially introduced with .NET 6. It incorporates many new features and enhancements, for example, AI IntelliCode that can auto-complete pieces of code for you and make the development experience easier. In this article, We’ll cover the Visual Studio 2022 Features that we found useful for developers. It’s Finally 64-digit…
Game-Changing Features of .NET 6
.
.NET 6 was released on November 8 2021. In this article, we will learn new features of .NET 6. Dot NET 6 conveys the latest pieces of the .NET unification plan that began with .NET 5. Dot NET 6 combines the SDK, base libraries, and runtime across mobile devices, desktops, IoT, gaming and cloud applications.…
Prototype Pattern in C# and .NET Core
.
In this article, we will learn Prototype Pattern in detail and then we will see how to implement this pattern in C# .NET Core based application. What is Prototype Pattern? A prototype pattern is basically to copy the objects to save time and resources while creating new instances. This pattern is the part of Creational…
Source Code Management Tools
.
In this article, we will take a look at the best Source code management tools that are accessible globally. What is Version Control System or Source Code Management? Version control or Source Code Management is a method for monitoring the progressions in the code so that assuming something turns out badly, we can find differences…
Layered Architecture – Definitions and Uses
.
The most well-known architecture design is the Layered Architecture design, also called the n-tier architecture design. The layered architecture design intently coordinates with the conventional IT correspondence and authoritative constructions seen as in most organizations, settling on it a characteristic decision for most business application development endeavours. Albeit the layered architecture design doesn’t indicate the…
Know everything about Good Software Architecture
.
In this article, we will look into details about Software Architecture or I would say a Good Software Architecture and related things. What is Software Architecture? Software architecture is the establishment of software, so software frameworks that do not have a strong architecture make it harder to meet the prerequisites as a whole. Poor architectures…
5 new features in C# 10
.
In this article, we will look into 5 new features in C# 10. .NET 6 was released on November 8, 2021, and C# 10 works with .NET 6. C# 10 new features C# 10 introduces below new features. 1. Record Structs The keyword Record was introduced with C# 9. Record is used to define reference…
Evolution of ASP.NET Framework to .NET Core
.
In this article, we will look into the Evolution of the .NET framework to .NET Core year by year. Dot Net or ASP.NET is a framework given by Microsoft for building desktop, mobile and web-based applications. It gives runtime, libraries, tooling and structures that empower you to develop any applications that you need. Contingent upon…
What is the difference between Blazor Server and Blazor WebAssembly?
.
Blazor is Microsoft’s latest web framework technology. In coming days it might be a popular choice for building web applications along with Dot Net framework such as .NET 5 or .NET 6. If you will open Visual Studio 2019, you may notice 2 project template. One is Blazor Server App and another is Blazor WebAssembly…
