<div>
Not via Lynq but Just loop through teachers and build email string<br />

<pre><code id="code-20-41997876-1">string emails = &quot;&quot;;
foreach (Teacher teacher in School.Teacher)
{
    If (emails != &quot;&quot;)
    {
        emails = emails + &quot;,&quot; + teacher.email;
    }
    else 
    {
        emails = teacher.email;
    }
}</code></pre>
I know you can do it via Lynq but against a string array...<br />

<pre><code id="code-20-41997876-2">string[] words = { &quot;word1&quot;, &quot;word2&quot;, &quot;word3&quot; };
string combined= words.Aggregate((current, next) =&gt; current + &quot;, &quot; + next);
Console.WriteLine(combined);</code></pre>
</div>


Not via Lynq but Just loop through teachers and build email string


string emails = "";
foreach (Teacher teacher in School.Teacher)
{
    If (emails != "")
    {
        emails = emails + "," + teacher.email;
    }
    else 
    {
        emails = teacher.email;
    }
}

I know you can do it via Lynq but against a string array...


string[] words = { "word1", "word2", "word3" };
string combined= words.Aggregate((current, next) => current + ", " + next);
Console.WriteLine(combined);

<div>
Both of these solutions meet the requirements of the question.
</div>


Both of these solutions meet the requirements of the question.

<div>
<div class="content wysiwyg-content">
Hello, I have a list of school objects that contain a list teacher objects from this I need to select a new object which contains the school-name, City, comma separated teacher-email<br />
<br />
<b>School</b><br />
name<br />
address<br />
city<br />
List&lt;Teacher&gt;<br />
<br />
<b>Teacher</b><br />
name<br />
email<br />
grade<br />
<br />
How can this be accomplished using Linq to query the list of schools?
</div>
</div>


Hello, I have a list of school objects that contain a list teacher objects from this I need to select a new object which contains the school-name, City, comma separated teacher-email

School
name
address
city
List<Teacher>

Teacher
name
email
grade

How can this be accomplished using Linq to query the list of schools?

With linq select new list containing comma seperated list

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.

LINQ Query

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.