Tutorials on ASP.NET Core, Blazor, jQuery, JavaScript, Entity Framework, Identity, WordPress, SQL, HTML & more


Implementing Clean Architecure by Steve “Ardalis” Smith GitHub Repository

Last Updated: March 14, 2024

Clean Architecture is a popular software development architecture which can be used in .NET apps. In this tutorial we are going to implement the Clean Architecure GitHub Repository by Steve "Ardalis" Smith, it can be downloaded from the GitHub Link.

(more…)

How to perform CRUD Operations in Dapper

Last Updated: March 15, 2024

In this Dapper CRUD operations tutorial we will be building CREATE, READ, UPDATE & DELETE features for 3 tables in a database. These tables are:

  1. School
  2. SchoolDetail
  3. Teacher
(more…)

How to Seed Database with Dapper

Last Updated: March 15, 2024

Dapper can be used to seed database with some initial set of data. This includes creating tables in the database, inserting records to the tables and so on. In this tutorial we will be seeding a database with Dapper. So let's start with the seeding process.

(more…)

Host ASP.NET Core on Apache in Windows

Last Updated: February 12, 2024

Apache Web Server can be used to host ASP.NET Core apps. Here Apache is used as a reverse proxy server to redirect traffic to an ASP.NET Core web app running on Kestrel server. We will set the whole process in Windows 10 Operating System.

(more…)

Dapper One-to-Many Relationship

Last Updated: March 15, 2024

In a relational database, 2 tables can be related with a Primary-Foreign key constraints. A very common relationships is One-to-Many where each record of one table are related to zero or more records of another table. In dapper we execute SQL JOIN Query with Dapper Query Method to retrieve records from the two table which are in One-to-Many relationship.

(more…)

Dapper One-to-One Relationship

Last Updated: March 15, 2024

In relational database, a table can be connected to another table using Primary-Foreign key constraints. In order to retrive connected records we apply SQL JOIN command. In Dapper we can apply the Dapper Query method to execute SQL query having JOIN command in order to get related records.

(more…)

Dapper Query Method – Execute SQL and Stored Procedure

Last Updated: March 14, 2024

Dapper Query method executes a SQL query or Stored Procedure and returns the result as a dynamic object. This dynamic object can then be mapped to C# strongly typed objects. The Query method takes a required SQL parameter and 3 optional parameters.

(more…)

Dapper Execute Method – Execute SQL and Stored Procedure

Last Updated: March 14, 2024

Dapper Execute method is used for exceuting an SQL query or Stored Procedure. It returns number of rows affected in the execute operation. This method is use for Inserting, Updating & Deleting records in the database.

The Exceute method can take upto 4 parameters, the first parameter "sql" specifies the sql statement or stored procedure name, it is required, while the other 3 parameters are optional.

(more…)

Create ASP.NET Core Minimal API from Start till Finish

Last Updated: October 21, 2023

Minimal APIs are used to create HTTP APIs in a quick span of time with minimum dependencies. They are best suited for microservices and apps that require only minimum files with minimum dependencies. In ASP.NET Core Minimal APIs we do not use controllers instead all the API codes are written in the Program.cs file.

(more…)

How to use jQuery submit() Method to submit a form

Last Updated: October 1, 2023

Use jQuery Submit Method - .submit(), to submit any form. The submit method can only be used for the form tag.

(more…)