invoke stored procedure passing a list in csharp

main.cs
using (SqlConnection con = new SqlConnection(connectionString))
{
    using (SqlCommand cmd = new SqlCommand("stored_procedure_name", con))
    {
        cmd.CommandType = CommandType.StoredProcedure;

        // Create a DataTable and add the list to it.
        // Here List<int> is used as an example.
        DataTable tvp = new DataTable();
        tvp.Columns.Add(new DataColumn("ID", typeof(int)));
        foreach (int item in myList)
        {
            tvp.Rows.Add(item);
        }

        // Add the DataTable as a SqlParamter of SqlDbType.Structured type
        SqlParameter parameter = new SqlParameter
        {
            ParameterName = "@ListParameter",
            SqlDbType = SqlDbType.Structured,
            TypeName = "dbo.CustomListType",
            Value = tvp
        };
        cmd.Parameters.Add(parameter);

        con.Open();
        var result = cmd.ExecuteNonQuery();
        con.Close();
    }
}
936 chars
31 lines