public dto.Employee Get(string name) { using (var connection = new MySqlConnection(_connectionString)) { connection.Open(); var cmd = new GetEmployeeCommand(name, connection); cmd.Execute(); connection.Close(); return(cmd.Result); } }