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


How to Seed Database with Dapper

Last Updated: February 20, 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: February 2, 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: January 7, 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 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: January 6, 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. These parameters are given below.

(more…)

Dapper Execute Method – Execute SQL and Stored Procedure

Last Updated: December 13, 2023

Dapper Execute method is used for exceuting an SQL query or Stored Procedure. It returns number of rows affeced 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, 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…)

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