using Dapper;

using System;

using System.Data.SqlClient;

using System.Linq;

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        List<int> output = null;

        List<int> input = new List<int> 

        {

            1, 2, 3

        };

        var sql = @"DECLARE @tempTable TABLE (Id INT)

                    INSERT INTO @tempTable VALUES (@Ids); 

                    SELECT * FROM @tempTable;";

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))

        {

            output = connection.Query<int>(sql, new { Ids = input }).ToList();

        }

        FiddleHelper.WriteTable(output);

    }

}