Tests.EmployeeRepositoryDapper.GetOfficePhoneNumbers C# (CSharp) Method

        public IList<EmployeeOfficePhone> GetOfficePhoneNumbers()
        {
            using (var con = new SqlConnection(m_ConnectionString))
            {
                con.Open();
                return con.Query<EmployeeOfficePhone>("SELECT e.EmployeeKey, e.FirstName, e.LastName, e.OfficePhone, e.CreatedDate FROM HR.Employee e").AsList();
            }
        }