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

How to perform CRUD Operations in Dapper

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

How to Seed Database with Dapper

Dapper can be used to seed a database with initial data, including creating tables and inserting records into them. In this tutorial, we'll walk through the process of seeding a database using Dapper. Let's get started.

Dapper One-to-Many Relationship

In a relational database, two tables can be related through primary and foreign key constraints. A very common relationship is One-to-Many, where each record of one table is related to zero or more records of another table. In Dapper, we execute a SQL JOIN query with the Dapper Query Method to retrieve records from two tables that are in a One-to-Many relationship.

Dapper One-to-One Relationship

In a relational database, tables are linked to each other through primary and foreign key constraints. To fetch related records from these linked tables, we use the SQL JOIN command. In Dapper, the Dapper Query method lets us run a SQL query containing a JOIN and retrieve the related records.

Dapper Query Method – Execute SQL and Stored Procedure

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 1 required SQL parameter and 4 optional parameters.

Dapper Execute Method – Execute SQL and Stored Procedure

Dapper's Execute method runs an SQL query or stored procedure and returns the number of rows affected. It is used for Inserting, Updating, and Deleting records in the database.