实体框架调用函数将 id 更改为名称

发布于 2024-12-14 21:59:28 字数 1099 浏览 0 评论 0原文

从此代码中收到的 DriverId 将是一个数字。

protected void Page_Load(object sender, EventArgs e)
{
    OrderDataRepository rep = new OrderDataRepository();

    var results = rep.GetAllOrderData().
                  GroupBy(o => o.DRIVER_ID).
                  Select(g =>
                            new
                            {
                                DriverId = g.Key,
                                OrderCount = g.Count(),
                                OrderCountWhereNameIsNotNull = 
                                                  g.Count(o => o.RECEIVE_NAME != null)
                            }).ToList();

    DataViewer.DataSource = results;
    DataViewer.DataBind();
}

我需要将此 DriverId 编号更改为名称 - 因此我需要调用另一个名为 get 的函数并接收名称。

public User Get(long userId)
{
    return GetQuery().Single(x => x.Id == userId);
}

公共用户调用一个实体“用户”，该实体具有“id”（即驱动程序 ID）和“名称”。我需要名字。

原文

The DriverId which will be received from this code will be a number.

protected void Page_Load(object sender, EventArgs e)
{
    OrderDataRepository rep = new OrderDataRepository();

    var results = rep.GetAllOrderData().
                  GroupBy(o => o.DRIVER_ID).
                  Select(g =>
                            new
                            {
                                DriverId = g.Key,
                                OrderCount = g.Count(),
                                OrderCountWhereNameIsNotNull = 
                                                  g.Count(o => o.RECEIVE_NAME != null)
                            }).ToList();

    DataViewer.DataSource = results;
    DataViewer.DataBind();
}

I need to change this DriverId number to a name - so I need to call another function called get and to receive a name.

public User Get(long userId)
{
    return GetQuery().Single(x => x.Id == userId);
}

public user get calling an entity "user" which has "id" which is the driverid and "name". I need the name.

分享到QQ

分享到微博

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

发布评论

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

睡美人的小仙女 2024-12-21 21:59:28

这行得通吗？

var results = rep.GetAllOrderData().
              GroupBy(o => o.DRIVER_ID).
              Select(g =>
                        new
                        {
                            DriverId = g.Key,
                            Name = g.Select(d => d.DRIVER_NAME).FirstOrDefault(),
                            OrderCount = g.Count(),
                            OrderCountWhereNameIsNotNull = 
                                              g.Count(o => o.RECEIVE_NAME != null)
                        }).ToList();

Would this work?

var results = rep.GetAllOrderData().
              GroupBy(o => o.DRIVER_ID).
              Select(g =>
                        new
                        {
                            DriverId = g.Key,
                            Name = g.Select(d => d.DRIVER_NAME).FirstOrDefault(),
                            OrderCount = g.Count(),
                            OrderCountWhereNameIsNotNull = 
                                              g.Count(o => o.RECEIVE_NAME != null)
                        }).ToList();

回复收藏 0 原文

~没有更多了~