转换IQueryable< object>结果以逗号分隔的字符串 [英] Converting IQueryable<object> results to comma delimited string

问题描述

我有一个LINQ查询，该查询返回员工的所有缺勤情况. linq语句的第一部分获得了雇员详细信息的基本列表，但我还返回了一个与该缺勤有关的疾病的IQueryable列表.

I have a LINQ query that returns all absences for an employee. The first part of the linq statement gets a basic list of the employees details, but I also return an IQueryable list of illnesses related to that absence.

我想以某种方式将该IQueryable列表转换为以逗号分隔的疾病列表.

I'd like to somehow convert that IQueryable list to a comma delimited list of Illnesses.

我目前使用(主要是精简版):

Currently I use (majorly stripped down):

DetailsOfSickness = (
  from t2 in Illnesses
  join ai1 in AbsenceIllnesses on t2.IllnessID equals ai1.IllnessID
  select new { Illness = ", " + t2.IllnessName })

哪个返回列表，但我希望得到以下结果:头痛，流感，痉挛...等. 有什么想法吗?

Which returns the list but I'd like the results like: Headache, Flu, Cramps.... etc. Any ideas?

推荐答案

您可以使用String.Join创建逗号分隔的字符串.

You can to use String.Join to create your comma delimited string.

string DetailsOfSickness = 
    String.Join(", ", (
      from t2 in illnesses
      join ai1 in absenceIllnesses on t2.IllnessID equals ai1.IllnessID
      select t2.IllnessName).ToArray());

这篇关于转换IQueryable< object>结果以逗号分隔的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！