如何在Mono上使用Linq和MySql数据库？

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

namespace MonoMySqlLinq
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Server=localhost;Database=mydatabase;Uid=myusername;Pwd=mypassword;";
            MySqlConnection connection = new MySqlConnection(connectionString);
            connection.Open();

            var query = from customer in connection.Query<Customer>("SELECT * FROM customers")
                        where customer.City == "New York"
                        select customer;

            foreach (var customer in query)
            {
                Console.WriteLine($"Customer Name: {customer.Name}, City: {customer.City}");
            }

            connection.Close();
        }
    }

    public class Customer
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public string City { get; set; }
    }
}