如何使用Dapper使用通配符

using System;
using System.Data.SqlClient;
using Dapper;

public class User
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Program
{
    private static string connectionString = "your_connection_string_here";

    public static void Main()
    {
        string searchTerm = "%keyword%"; // 使用 % 通配符进行模糊匹配

        using (var connection = new SqlConnection(connectionString))
        {
            connection.Open();

            var sql = "SELECT Id, Name FROM Users WHERE Name LIKE @SearchTerm";
            var users = connection.Query<User>(sql, new { SearchTerm = searchTerm }).ToList();

            foreach (var user in users)
            {
                Console.WriteLine($"Id: {user.Id}, Name: {user.Name}");
            }
        }
    }
}

var sql = "SELECT Id, Name FROM Users WHERE Name LIKE @SearchTerm";
var users = connection.Query<User>(sql, new { SearchTerm = searchTerm }).ToList();

var sql = "SELECT Id, Name FROM Users WHERE Name LIKE @SearchTerm ORDER BY Id OFFSET @Offset ROWS FETCH NEXT @PageSize ROWS ONLY";
var users = connection.Query<User>(sql, new { SearchTerm = searchTerm, Offset = offset, PageSize = pageSize }).ToList();