在Entity Framework中通过字符串获取实体

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

public class MyDbContext : DbContext
{
    public DbSet<Customer> Customers { get; set; }
    // 其他DbSet属性...
}

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

public class Program
{
    public static void Main()
    {
        using (var context = new MyDbContext())
        {
            string entityTypeName = "Customer"; // 这个字符串可以来自用户输入或其他动态源
            Type entityType = Assembly.GetExecutingAssembly().GetTypes().FirstOrDefault(t => t.Name == entityTypeName);

            if (entityType != null && typeof(Entity).IsAssignableFrom(entityType))
            {
                var dbSetProperty = typeof(MyDbContext).GetProperty(entityTypeName + "s");
                if (dbSetProperty != null)
                {
                    var dbSet = dbSetProperty.GetValue(context) as IQueryable;
                    var query = dbSet.Cast<object>().Where(e => (e as Customer).Name == "John Doe"); // 示例查询
                    foreach (var item in query)
                    {
                        Console.WriteLine(((Customer)item).Name);
                    }
                }
            }
        }
    }
}