How can a SQL statement be relayed?

Question

C++ / C#

In trying to relay this SQL statement to LINQ, I'm completely confused

SELECT Project.name AS Project, count(distinct Test.name) AS TEST_COUNT
FROM Project
JOIN Test ON Test.project_id = Project.id
GROUP BY Project.Name

The difficulty itself arose in the relaying of this string count(distinct Test.name)
I don’t quite understand how it can be implemented in Linq

Answer 1

It is possible like this:

var results1 = projects.Select(p => new
            {
                Id = p.Id,
                Name = p.Name,
                Count = tests.Where(t => t.ProjectId == p.Id).Select(x => x.Name).Distinct().Count()
            });