sql - i want to convert sql query to linq and store to model

Question

this my sql query that i want to convert into linq

  SELECT 
  s.Studentname ,
  COUNT(c.StudentId) as Counts
  FROM  Students s,  StudentCourses c

  where s.StudentId=c.StudentId

  group by s.Studentname

 GO   

here is what i have tried i specificaly wanted to store data into StudentDto Model

        var students = (from s in DbContext.students
                                join sc in DbContext.studentCourses on s.StudentId equals 
                                sc.StudentId
                                group s by s.Studentname into grouped
                                select new StudentDto()
                                {
                                    Studentname = s.StudentName,
                                    StudentEmail = s.StudentEmail,
                                    PhoneNumber = s.PhoneNumber,
                                    DateOfBirth = s.DateOfBirth,
                                    Password = s.Password,
                                    ConfirmPawword = s.ConfirmPawword,
                                    CourseCount = sc.count()
                                }
                                ).ToList();

标签： sqlentity-frameworklinq