C#

using (SqlConnection dbConnection = new SqlConnection(connString))
{
    using (SqlCommand dbCommand = new SqlCommand("SELECT * FROM [TableName]", dbConnection))
    {
        using (SqlDataReader dbReader = dbCommand.ExecuteReader())
        {
            while (dbReader.Read())
            {
                //Do Stuff
            }
        }
    }
}

using (var dbConnection = new SqlConnection(connString))
{
    using (var dbCommand = new SqlCommand("SELECT * FROM [TableName]", dbConnection))
    {
        using (var dbReader = dbCommand.ExecuteReader())
        {
            while (dbReader.Read())
            {
                //Do Stuff
            }
        }
    }
}

class Employee
    {
        int div_Id;
        public string Name { get; set; }
        public bool IsTL { get; set; }
       

        public Employee(string name, bool isTL, int divid)
    {
        this.Name = name;
        this.IsGR = isTL;
        this.div_Id = divid;
    }
}
class Batch
{
public int AddEmployee(IEmployee employee)
        {
            iemplist.Add(employee);
            employeeid=0;
            foreach (Employee a in iemplist)
            {
                ++employeeid;
            }
        }
public list<IEmployee> ViewAllEmployees() //is this correct???
{  
           foreach (Employee i in iemplist)
            {
                Console.WriteLine("EmployeeName: {0}", i.Name);
                Console.WriteLine("IsTL: {0}", i.IsGR);
                // i want view the employeeid also.. how do i?
            }
            return iemplist;
}
 }
class Program
{
static void Main(string[] Args)
{
Batch bat= new Batch();
List<IEmployee> iemplist = new List<IEmployee>();
int EmployeeId;
string name;
bool isTL;
int div_id;
// case 2 is for generating associate id. 
 case 2:
                        {
                            Console.WriteLine("enter the employee name and div_id");
                            name = Console.ReadLine();
                            isTL = false;
                            div_id = Convert.ToInt32(Console.ReadLine());
                           Employee emp = new Employee(name, isTL, div_id);
                            EmployeeId = bat.AddEmployee(emp);
                            Console.WriteLine("Employee Id = " + EmployeeId);
                            break;
                        }
               case 3:
                        {
                            var s = bat.ViewAllEmployees();     
                            break;
                        }
}
}