更改 IQueryable 对象中的数据

发布于 2024-12-29 13:49:30 字数 568 浏览 1 评论 0原文

我有一个像这样的 IQueryable 对象

var persons = from m in db.Persons
              select m;

返回的字段将是：name: String, family: String, cityID: Int在其中。我有另一个 IQueryable 对象，它从另一个表中获取 cityID: Int 和 CityName: String ，如下所示：

var citys = from x in db.CitysInfo
            select x;

现在我想要一个 IQueryable 对象，具有name: String、family: String、CityName: String。我怎样才能做到这一点？

原文

I have an IQueryable object like this

var persons = from m in db.Persons
              select m;

The returned fields will be: name: String, family: String, cityID: Int in it. I have another IQueryable object that get cityID: Int and CityName: String from another table like one here:

var citys = from x in db.CitysInfo
            select x;

Now I want an IQueryable object that have name: String, family: String, CityName: String. How can I do that?

分享到QQ

分享到微博

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

发布评论

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

小矜持 2025-01-05 13:49:30

您可以使用连接并投影到匿名类：

var results = from p in db.Persons 
              join c in db.CitysInfo on p.cityID equals c.cityId
              select new 
              {
                name = p.name,
                family = p.family,
                CityName = c.CityName,
              }

You could use a join and project to an anonymous class:

var results = from p in db.Persons 
              join c in db.CitysInfo on p.cityID equals c.cityId
              select new 
              {
                name = p.name,
                family = p.family,
                CityName = c.CityName,
              }

回复收藏 0 原文

~没有更多了~