In this article, we are going to cover how to build APIs with Node.js, Express and MySQL.

In this article, we are going to cover how to build APIs with Node.js, Express and MySQL. As we all know, JavaScript is the most popular language because we can easily build both front-end and back-end services with it.

What are we going to cover in this?

  • Installation of required packages
  • Database Configuration setup
  • CRUD Methods
  • Execution of Stored Procedure

Step 1

Create a folder with the project name and open the folder in Visual Studio Code and open the command prompt (Win + R -> cmd) or terminal in VS Code and…


In this article we are going to learn about the how to setup the basic authentication for our API’s using swagger in ASP.NET 5.0. As we all know, its newly launched Framework officially released in November. Here I am sharing the link to install the SDK for .Net 5

GitHub Repo

Packages used in this Project!

  1. Swashbuckle.AspNetCore (latest version)

The above package is installed by default if you are going with ASP.NET Core 5.0

Step 1

Create a Project in Visual Studio and make sure to go with the same process from the image shown below.


In this article we will learn about the Hangfire — .Net Library to make our background tasks and jobs easier in ASP.NET 5.0. As we all know, its newly launched Framework officially released in November. Here I am sharing the link to install the SDK for .Net 5

Prerequisites

  1. What is Hangfire and why do I need background tasks.
  2. Setup and Configure Hangfire
  3. Secure the Hangfire Dashboard.
  4. Hangfire Retention Time.
  5. Persistence with SQL Database.

What is Hangfire and why do we need to use this?

Hangfire is a .Net Library that helps to create background tasks and make jobs easier in .Net applications. It supports all types of tasks like “fire…


Today we are going to learn about Microservice architecture and its implementation using Ocelot API Gateway in ASp.Net Core — 3.1. We all know the benefits of using Microservices for large-scale applications.

Microservice Architecture — Overview

There are two possible ways to build and structure the applications:

  1. Monolith Architecture
  2. Microservices Architecture

Monolith Architecture

Monolith is like a big container, wherein all the software components of an app are assembled and tightly coupled; i.e each component fully depends on the other. There are advantages and disadvantages to Monolith. Compared to Microservices the advantages are less in Monolith Architecture.


First of all, let’s have a clear look at Dapper and how it will be useful in our Core API. I think most of us know what Dapper is, but this article is for those who don’t know about Dapper.

Dapper

Dapper is a simple Object Mapper and is nothing but Object-relational mapping (ORM) and is responsible for mapping between database and programming language and also it owns the title of King of Micro ORM in terms of speed. It is virtually as fast as using a raw ADO.NET data reader and also Entity Framework.

How Does Dapper Work?

  1. Creates an…


Introduction

Hello everyone. As we all know, Microsoft has recently launched a .NET 6 preview and confirmed it on their official blog site. With the new version of .NET after the .NET 5 release, there have been significant improvements that Microsoft is doing for this .NET 6 stable release for LTS (Long Time Support). In this article, we will see how to set up the .NET 6 (Preview) in Visual Studio.

Installations


Introduction

This article is meant to make the process of authentication and authorization easier using JSON Web Tokens and also to check the entire process with Swagger UI rather than PostMan.

What is ASP.Net Core?

ASP.NET Core is an open-source and cloud-optimized web framework for developing modern web applications that can be developed and run on Windows, Linux, and Mac. It includes the MVC framework, which now combines the features of MVC and Web API into a single web programming framework.

  • ASP.NET Core apps can run on .NET Core or on the full .NET Framework.
  • It was built to provide an optimized development framework for…


Introduction

These days everyone wants to know how much time we spend on each task and also what task took the most time in developing and building the applications and products using Visual Studio. It also saves time that we are working on our projects.

We have many tools in the market which help us to get the result. Here is the extension which helps us in tracking all of this.

What is the extension? It’s Visual Time Spent.

Let’s go deep into this..!

What is Visual Time Spent?

Visual Time Spent automatically tracks your time spent working on any project…


CODEX

In this article, we will cover all the new feature in SQL Server 2019.

The previous version of SQL 2017 came with support for Linux (Redhat, Ubuntu, Linux Server) and Docker engine, and that was the big step by the SQL Team.

SQL Server 2019

We can select the desired Operating system version to install SQL Server 2019 and now we can build this on Windows, Linux, Docker, and Big Data Analytics containers with Kubernetes images as well.


Introduction

We assume that the reader knows the basics of debugging in Visual Studio but we will dive into some major concepts in debugging.

Many developers handle their debugging sessions with this powerful-enough knowledge kit. However, Visual Studio Debugging tools have much more to offer. Here is a list of Visual Studio Debugging productivity tips. Note that those tips and shortcuts have been validated with Visual studio 2019 16.6 with no extension installed.

Run to Cursor

With the shortcut Ctrl+F10, you can tell the debugger to run until the line pointed by the cursor.

Jaykrishnareddy

Programmer 💻 | Biker 🏍️ | Blogger 👨‍💻 | Indian

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store