我正在尝试运行LINQ to SQL查询,该查询在搜索引擎样式列表的网格视图中返回结果。
在下面的简化示例中,是否可以使用逗号分隔的列表来填充集合,该列表包含父查询(NAMESOFCHILDREN)在单个查询中的所有子项?
var family = from p in db.Parents
where p.ParentId == Convert.ToInt32(Request.QueryString["parentId"])
join pcl in db.ParentChildLookup on p.ParentId equals pcl.ParentId
join c in db.Children on pcl.ChildId equals c.ChildId
select new
{
Family = "Name: " + p.ParentName + "<br />" +
"Children: " + NAMESOFCHILDREN? + "<br />"
};
提前致谢。
发布于 2018-08-29 11:11:19
你可以尝试如下:
var family = from p in db.Parents
where p.ParentId == Convert.ToInt32(Request.QueryString["parentId"])
join pcl in db.ParentChildLookup on p.ParentId equals pcl.ParentId
select new {
Family = "Name: " + p.ParentName + "<br />" + string.Join(",",(from c in db.Children where c.ChildId equals pcl.ChildId select c.ChildId.ToString()).ToArray());
};
https://stackoverflow.com/questions/-100000683
复制相似问题