how to write sql query in following format

See more:

C#

ASP.NET

SELECT TOP 3 * FROM tbl_LectureScheduling

ORDER BY StartDateTime DESC


I am writing SQL code in .cs file in .NET. So I am usually writing code in following format :

var query =  from LectureAttendance in context.tbl_LectureAttendence
                              join LectureSchedulling in context.tbl_LectureScheduling on LectureAttendance.LectureScheduleID equals LectureSchedulling.LectureScheduleID
                              join Lectures in context.tbl_Lectures on LectureSchedulling.LectureID equals Lectures.LectureID
                              where LectureAttendance.StudentID ==  StudentID
                              select new
                                 {
                                     LectureAttendance.StudentID,
                                     LectureAttendance.LectureScheduleID,
                                     LectureAttendance.status,
                                     LectureSchedulling.LectureID,
                                     LectureSchedulling.StartDateTime,
                                     Lectures.LectureName,

                                   
                                 };

So I dont know how to write above sql query in this format as this is .cs file which does not support keywords like "TOP" and "Order By".