using Dapper;

using Moq;

using Moq.Dapper;

using System;

using System.Data.Common;

using System.Collections.Generic;

using System.Linq;

using Xunit;

​

public class ClerkItem

{

    public string Name { get; set; } = "";

    public ClerkItem()

    {

    }

    public ClerkItem(string name)

    {

        Name = name;

    }

}

​

public class Program

{

    public static void Main()

    {

        Program.RunTest();

    }

    protected async static void RunTest()

    {

        var connection = new Mock<DbConnection>();

        var input = new List<ClerkItem>() { new ClerkItem("Joseph"), new ClerkItem("Georgia"), new ClerkItem("William") };

        var expected = new[] { input };

        connection

            .SetupDapperAsync(c => c.QueryAsync<List<ClerkItem>>(It.IsAny<string>(), null, null, null, null))

            .ReturnsAsync(expected);

​

        var result = await connection.Object.QueryAsync<ClerkItem>(

            "SELECT * FROM Clerk WHERE Location=@Location", 

            new { Location = "0000" }

        );

        var output = result.ToList();

        Console.WriteLine($"output.Count={output.Count}, input.Count={input.Count}");

        Console.WriteLine($"output.Name={output[0].Name}");

        Console.WriteLine($"input.Name={input[0].Name}");

    }

}

​