GET Requests
JumpKick.HttpLib — GET Requests 1. Basic Syntax 1: Minimal Working Request (no exception handling) Without OnFail, any network error will crash your program with a popup error dialog 2: Success …
Overview
Brief Introduction to HttpLib (C# .NET Framework) 1. Library Overview HttpLib (by James Thorne) is a .NET HTTP request helper library released under the Apache 2.0 License. It simplifies asynchronous …
Multi‑table JOIN relational query
Dapper Query<T1,T2,TReturn>() implements one‑to‑one table join mapping Example 1. Entity Class Definition 2. Query Implementation Multi‑table JOIN relational query
Multi‑statement Operations
Dapper Multi‑Statement Operations with QueryMultiple Example Parameter‑Based Multi‑Statement Query Multi‑statement Operations
IN Query
Example Both parameter formats work Bulk Delete Multi‑condition IN Query IN Query
Dapper Stored Procedures
Create MySQL Stored Procedure Call the Stored Procedure Stored Procedure Returning Result Sets Use .Query<T>() when your stored procedure returns query data Dapper Stored Procedures
Dapper delete operation
Original note: Entity deletion generally relies on a unique Id; core SQL pattern: DELETE … WHERE PrimaryKey=Value The example below is vulnerable to SQL injection Standard Parameterized Implementation Pass Parameters …
Update operation
Original note: The update workflow is similar to inserts; write your UPDATE SQL and add a WHERE clause so only target rows get modified. Example Standard Parameterized Implementation Partial‑field Only …
Insert
Dapper Insert Operations Example Notes Retrieve Auto‑Increment Primary Key ID for New Records (MySQL) If the student table has an auto‑increment primary key Id, fetch the ID of the newly‑added …
First example
Dapper supports many databases. We will use MySQL as our example here. You need to have MySQL installed on your system beforehand. Once MySQL is installed, create a new database. …