vs怎么读取mysql数据库条目

using MySql.Data.MySqlClient;
using System;
using System.Data;

public class DatabaseReader
{
    private static string connectionString = "server=localhost;port=3306;database=mydatabase;uid=myuser;password=mypassword";

    public static void ReadEntries()
    {
        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            try
            {
                connection.Open();
                string query = "SELECT * FROM mytable";
                MySqlCommand command = new MySqlCommand(query, connection);
                MySqlDataAdapter adapter = new MySqlDataAdapter(command);
                DataTable dataTable = new DataTable();
                adapter.Fill(dataTable);

                foreach (DataRow row in dataTable.Rows)
                {
                    Console.WriteLine($"ID: {row["id"]}, Name: {row["name"]}");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
            }
        }
    }
}

using Microsoft.EntityFrameworkCore;
using System;
using System.Linq;

public class MyDbContext : DbContext
{
    public DbSet<MyEntity> MyEntities { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseMySQL("server=localhost;port=3306;database=mydatabase;uid=myuser;password=mypassword");
    }
}

public class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class EntityReader
{
    public static void ReadEntries()
    {
        using (MyDbContext context = new MyDbContext())
        {
            try
            {
                var entities = context.MyEntities.ToList();
                foreach (var entity in entities)
                {
                    Console.WriteLine($"ID: {entity.Id}, Name: {entity.Name}");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
            }
        }
    }
}