Как выполнить итерацию по нескольким строкам в таблице данных SQL server 2012 ?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace sqlserver_database_ex_cp2
{
    class Program
    {
        static void Main(string[] args)
        {
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = "Data Source=DESKTOP-F49I231;Initial Catalog=company;Integrated Security=True";

                conn.Open();
                //create the command

                SqlCommand command = new SqlCommand("select * from dbo.Employees where EMP_No =@param1", conn);

                //add the parameters
                

                command.Parameters.Add(new SqlParameter("param1", 1));
            
                /* get the rows and display on the screen
                 *This section of the code has the basic code
                 * that will the display the content from the database table.
                 * on the screen using the sqlDataReader */
                 
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    Console.WriteLine("EMP_NO\tEMP_NAME\tEMP_JOIN_DATE\tEMP_DEPT");

                    while(reader.Read())
                    {
                        Console.Write(string.Format("{0}\t| {1} \t | {2} \t | {3}", reader[0],
                            reader[1], reader[2], reader[3]));


                    }
                }

               
                        

            



            }
        }
    }
} 
I want all the rows to be displayed on the console. Please, help me.

What I have tried:

Whatever I have tried, mentioned in the code.