datasource incorrect for MySQl in text unit in c#

I would like to use a database MySQl in a test unit c#.
It's ok for xml or a database access but i don't find the good "datasource" for a database MySQL
please, help me !
differents tests here :
//TEST avec BDD ACCESS
//[DataSource(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source = C:\Users\LAMSQ\Dropbox\coursBTS20152016\EPSI\modulecScharpetobjet\supportTestsUnitaires\supporttestunitaire.accdb;", "mention")]

    //TEST AVEC BDD MYSQL
    //[DataSource("testunitaireConnectionStringMySQL", "valeurstests")]
    //[DataSource("Server=127.0.0.1;Database=testunitaire;Uid=root;Pwd=","valeurstests")]
     [DataSource(@"server=127.0.0.1;user id = root; database=testunitaire","valeurstests")]
    //TEST AVEC FICHIER XML
    //[DataSource("Microsoft.VisualStudio.TestTools.DataSource.XML", "|DataDirectory|\\XMLtestDonneMention.xml", "valeurTest", DataAccessMethod.Sequential), DeploymentItem("testsMesFonctionsEtProcédures\\XMLtestDonneMention.xml")]
    public void donneMentionTest()
    {
        MesFonctionsEtProcédures target = new MesFonctionsEtProcédures();
        double note = double.Parse(TestContext.DataRow["note"].ToString());
        string expected = TestContext.DataRow["mention"].ToString();

1 answer