DataBaseは、SQL Serverで、データはAdventureWorks2022をいれています
→AdventureWorksについて

複数データが返ってくる場合は、以下メソッドを使います

• Query
• QueryAsync

サンプル：
Employee.cs

namespace SampleDapper.Models.HumanResources
{
    public class Employee
    {
        // テーブルから取得したい列の情報を定義
        public int BusinessEntityID { get; set; }
        public string JobTitle { get; set; } = null!;
        public DateTime BirthDate { get; set; }
        public char Gender { get; set; }
        public DateTime HireDate { get; set; }
    }
}

Program.cs

using Dapper;
using Microsoft.Data.SqlClient;
using Microsoft.Extensions.Configuration;
using SampleDapper.Models.HumanResources;

try
{
    var config = new ConfigurationBuilder()
                    .SetBasePath(Directory.GetCurrentDirectory())
                    .AddJsonFile(@"appsettings.json")
                    .Build();

    var connectStr = config["ConnectionStrings:DefaultConnection"];

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

        // 任意の件数、取得するSQL
        var sql = "SELECT * FROM HumanResources.Employee WHERE Gender = @Gender AND JobTitle = @JobTitle";

        //　SQL中のパラメータに渡す値を設定
        var parameters = new { Gender = 'F', JobTitle = "Design Engineer" };

        var recordList = connection.Query<Employee>(sql, parameters);
    }
}
catch(Exception ex)
{
    Console.Write(ex.ToString());
}