如何从NUnit测试项目连接到数据库？

using NUnit.Framework;
using MySql.Data.MySqlClient;

namespace YourNamespace
{
    [TestFixture]
    public class DatabaseTests
    {
        private MySqlConnection connection;

        [SetUp]
        public void Setup()
        {
            string connectionString = "server=localhost;user=root;database=mydatabase;password=mypassword";
            connection = new MySqlConnection(connectionString);
            connection.Open();
        }

        [Test]
        public void TestDatabaseQuery()
        {
            // Execute your database query here
            MySqlCommand command = new MySqlCommand("SELECT * FROM mytable", connection);
            MySqlDataReader reader = command.ExecuteReader();

            // Process the query results
            while (reader.Read())
            {
                // Do something with the data
            }

            reader.Close();
        }

        [TearDown]
        public void Teardown()
        {
            connection.Close();
        }
    }
}