Image Analysis in ASP.NET Core 5.0 using Azure Cognitive Service

Background Azure’s computer vision services give wide range of options to do image analysis. These AI services enable to discover the content and analyze images and videos in real time. Using computer vision which is a part of azure cognitive services, we can do image processing to label content with objects, moderate content, identify objects in image, extract text, generate details descriptions of the image, … Continue reading Image Analysis in ASP.NET Core 5.0 using Azure Cognitive Service

Upload Single or Multiple Files in ASP.NET Core Razor Pages with Insights

In this article, I will explain some file upload insights and show how to upload single or multiples in app.net razor pages application. I will cover following points: File Upload approaches: Buffering and Streaming File upload security concerns File Upload Storage options Upload Single File in asp.net core razor pages   Upload Multiple files Storing files in physical storage and database Source Code >> GitHub … Continue reading Upload Single or Multiple Files in ASP.NET Core Razor Pages with Insights

How to Compare Two Databases, find differences and update using Visual Studio

In this article, we are going to learn how to compare two databases using SQL Server Database Project (Template) available in Visual Studio. I will cover the following points: Introduction of SQL Server Database Project. Connect two databases: source and target. Compare and identify differences among the two databases. Update or generate script to update the target database.  In the last article, we learned how … Continue reading How to Compare Two Databases, find differences and update using Visual Studio

ASP.NET Error: The entry ‘DefaultConnection’ has already been added. (C:\..\web.config line ..)

Recently, we were facing this error while deploying the asp.net solution into server (IIS) as a separate application (Sub Domain) in a main web application. Scenario I created a website ( say site mymainsite ) in window server IIS under a port and then added an another application ( plugin ) under a root-site ( mymainsite ) as shown: After deploying the solution, when I … Continue reading ASP.NET Error: The entry ‘DefaultConnection’ has already been added. (C:\..\web.config line ..)

When to use .NET Framework and .NET Core

Introduction This write up will describe differences and when to use .NET Framework and .NET Core shortly. This will help reader to understand and use it in proper situation. What is .NET Core? It is open source cross platform to develop application which runs on Windows, Linux, and Mac OS. Latest Version 3.0. This is the much-improved version of .NET core as of now. .NET … Continue reading When to use .NET Framework and .NET Core

Add-Migration : The term ‘Add-Migration’ is not recognized

Details error: Solution Simply, install Microsoft.EntityFrameworkCore.Tools package from nuget: Install-Package Microsoft.EntityFrameworkCore.Tools -Version 3.1.6 You can also use this link to install the latest version: Nuget package link Tips: Install latest stable version. Sometimes, the error persists because of cache, so restart can solve the issue without doing anything. Continue reading Add-Migration : The term ‘Add-Migration’ is not recognized

Failed to register URL “http://localhost:XXXX/” for site “..” application “/”. Error description: The process cannot access the file because it is being used by another process. (0x80070020)

Error: Failed to register URL “http://localhost:XXXX/” for site “SITE NAME” application “/”. Error description: The process cannot access the file because it is being used by another process. (0x80070020) **XXXX = port number Reason for this error: This error happens to me because I was using same solution for different project. I copied the solution and created another one in different location. I have done … Continue reading Failed to register URL “http://localhost:XXXX/” for site “..” application “/”. Error description: The process cannot access the file because it is being used by another process. (0x80070020)

Create a Database View using Entity Framework (EF) Code First Approach

How to create a database view using Entity Framework Code first approach? User case scenario: There are several cases that the aplications may need to display the data by combiniting two or more tables, sometimes even more than 7-8 tables. In such scenario, using entity framework may results in slow performance beacause we need to process by selecting data from a table then running loop … Continue reading Create a Database View using Entity Framework (EF) Code First Approach

How to Create SQL Server Database Project With Visual Studio

In this article, we are going to learn about SQL Server Database Project (Template) available in Visual Studio. I will cover the following points, Introduction of SQL Server Database Project. Create New SQL Server Database Project. Import database schema from an existing database, a .sql script file or a Data-tier application (.bacpac) the Project. Publish to create new Database in SQL server. The database plays … Continue reading How to Create SQL Server Database Project With Visual Studio