动态排序和过滤预计的 Entity SQL 结果

发布于 2024-09-26 19:07:58 字数 812 浏览 4 评论 0原文

我有以下查询，我想使用投影类名称对其进行排序或过滤：

List<CompanyInfo> list = new List<CompanyInfo>();

using (var db = new DbContext())
{
    list.AddRange(
                  db.Companies.Include("Projects")
                  .Select(row => new CompanyInfo()
                  {
                      ProjectCount = (from s in row.Projects
                                      where s.Company.fId == row.fId
                                      select s.pId).Count(),
                      Id = satir.fId,
                  })
                 //.OrderBy("ProjectCount") //<== what I want to do
            );
}

我想使用与 ESQL 相同的 ProjectCount 或 Id 列动态排序此查询，例如 .OrderBy("ProjectCount").由于查询结果是 IQueryable 而不是 ObjectContext，因此它不起作用。有办法做到这一点吗？

原文

I have the following query which I want to sort or filter using projected class names:

List<CompanyInfo> list = new List<CompanyInfo>();

using (var db = new DbContext())
{
    list.AddRange(
                  db.Companies.Include("Projects")
                  .Select(row => new CompanyInfo()
                  {
                      ProjectCount = (from s in row.Projects
                                      where s.Company.fId == row.fId
                                      select s.pId).Count(),
                      Id = satir.fId,
                  })
                 //.OrderBy("ProjectCount") //<== what I want to do
            );
}

I want to dynamically order this query using ProjectCount or Id columns same as ESQL, like .OrderBy("ProjectCount"). Since the query result is IQueryable instead of ObjectContext it doesn't work. Is there a way to do this?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

还给你自由 2024-10-03 19:07:58

您应该能够这样做： .OrderBy(p => p.ProjectCount)

回复收藏 0 原文

很糊涂小朋友 2024-10-03 19:07:58

看一下动态 LINQ 库。
这是一个教程似乎描述了您的情况。

回复收藏 0 原文

小嗷兮 2024-10-03 19:07:58

如果您知道该怎么做，您可以使用 LINQ 做一些有趣的事情。也许是这样的？

        var query = db.Companies.Include("Projects").Select(row => 
            new CompanyInfo() 
            { 
                ProjectCount = (from s in row.Projects where s.Company.fId == row.fId select s.pId).Count(), 
                Id = satir.fId, 
            });

        if (orderBy) // orderBy is bool, that tels you what to order by
            query = query.OrderBy(x => x.ProjectCount);
        else
            query = query.OrderBy(x => x.Id);

        list.AddRange(query);

You can do some nifty things with LINQ, if you know what to do. Maybe something like this??

        var query = db.Companies.Include("Projects").Select(row => 
            new CompanyInfo() 
            { 
                ProjectCount = (from s in row.Projects where s.Company.fId == row.fId select s.pId).Count(), 
                Id = satir.fId, 
            });

        if (orderBy) // orderBy is bool, that tels you what to order by
            query = query.OrderBy(x => x.ProjectCount);
        else
            query = query.OrderBy(x => x.Id);

        list.AddRange(query);

回复收藏 0 原文