Mono 实体框架 6 MySQL

csharp
using System;
using System.Linq;
using Microsoft.EntityFrameworkCore;
namespace MyApplication
{
    public class MyEntity
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }
    public class MyDbContext : DbContext
    {
        public DbSet<MyEntity> MyEntities { get; set; }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseMySQL("server=localhost;Database=myDatabase;user=root;password=123456");
        }
    }
    public class Program
    {
        public static void MAIn(string[] args)
        {
            using (var context = new MyDbContext())
            {
                // 添加数据
                context.MyEntities.Add(new MyEntity { Name = "Entity 1" });
                context.MyEntities.Add(new MyEntity { Name = "Entity 2" });
                context.SaveChanges();
                // 查询数据
                var entities = context.MyEntities.ToList();
                foreach (var entity in entities)
                {
                    Console.WriteLine(entity.Name);
                }
                // 更新数据
                var entityToUpdate = context.MyEntities.FirstOrDefault(e => e.Id == 1);
                if (entityToUpdate != null)
                {
                    entityToUpdate.Name = "Updated Entity";
                    context.SaveChanges();
                }
                // 删除数据
                var entityToDelete = context.MyEntities.FirstOrDefault(e => e.Id == 2);
                if (entityToDelete != null)
                {
                    context.MyEntities.Remove(entityToDelete);
                    context.SaveChanges();
                }
            }
        }
    }
}