public List <User> List() { var usersResponse = new List <User> (); using (SqlConnection conn = new SqlConnection(ConnectionString())) { using (var cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = _userSql.SqlList(); cmd.CommandType = CommandType.Text; conn.Open(); using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { User user = new User(); user.Id = Convert.ToInt32(dr["Id"].ToString()); user.Name = dr["Name"].ToString(); user.Email = dr["Email"].ToString(); usersResponse.Add(user); } } } } return(usersResponse); }