You're on the right track.
var query = from stud in Students
select new
{
ParentName = (from emp in EmplyeeList where emp.childId = stud.id select new { pname = string.Concat(emp.fname, " ", emp.lastname) }).First()
Name = stud.name,
Address= stud.address
};
But... your query needs optimization by using
joins[
^].
For further details, please see:
Visual Representation of SQL Joins[
^]
101 LINQ Samples in C#[
^]
linq101-lambda[
^]