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


Host ASP.NET Core on Apache in Windows

Last Updated: June 2, 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: March 16, 2024

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…)

OperaVPS: Your Go-To VPS Provider Company

Last Updated: September 10, 2023

The importance of a reliable Virtual Private Server (VPS) provider cannot be overstated. Your website's performance, security, and overall user experience often hinge on the quality of your VPS hosting. When it comes to finding the best VPS provider, look no further than operavps.com In this comprehensive guide, we will delve into what makes operavps stand out in the competitive world of VPS hosting.

(more…)

jQuery Show() Method – To Show Hidden elements in your web page

Last Updated: April 8, 2023

The jQuery Show method is used to un-hide (show) hidden elements in a web page. This is similar to the CSS property display:block.

(more…)

ZXing.Net implementation in ASP.NET Web Forms

Last Updated: February 5, 2023

ZXing.NET is a library which supports decoding and generating of barcodes (like QR Code, PDF 417, EAN, UPC, Aztec, Data Matrix, Codabar) within images. In this tutorial I will implement it in ASP.NET Web Forms.

(more…)