using MySql.Data.MySqlClient; using System;

namespace Desafio_07.Entidades { public class DAOAluno : IDaoBase { public void SalvarDados(dynamic addAluno) { try { using (MySqlConnection destinoMySQL = new MySqlConnection()) { destinoMySQL.ConnectionString = "server=localhost;database=database_desafio_07;uid=root;pwd=29101990lrwj;port=3306"; destinoMySQL.Open();

                string comandoMySQL = "INSERT INTO aluno(Nome,Cpf,Nota)VALUES('"+ addAluno.Nome + " ',' " + addAluno.Cpf + " ', " + addAluno.Nota + ");";
                MySqlCommand mySqlCommand = new MySqlCommand(comandoMySQL, destinoMySQL);                    
                mySqlCommand.ExecuteReader();


                Console.WriteLine("Aluno Cadastrado!");
                destinoMySQL.Close();
            }
        }
        catch (Exception exce)
        {
            throw new Exception(exce.Message);
        }
    }
}

}