如何查询由EntityFrameworkCore生成的联接或通用表？

通过在DbContext中创建DbSet对象，在LINQ查询中使用Join方法或Where方法对生成的联接或通用表进行查询。以下是示例代码：

在DbContext中定义DbSet：

public class MyDbContext : DbContext { public DbSet<Product> Products { get; set; } public DbSet<Order> Orders { get; set; } public DbSet<OrderItem> OrderItems { get; set; }

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    // configure entity relationships here
}

}

查询联接表：

var query = from order in dbContext.Orders join orderItem in dbContext.OrderItems on order.OrderId equals orderItem.OrderId join product in dbContext.Products on orderItem.ProductId equals product.ProductId select new { OrderId = order.OrderId, ProductName = product.ProductName };

查询通用表：

var query = dbContext.Set<MyTable>() .Where(t => t.ColumnName == "value") .OrderBy(t => t.Id) .ToList();