Sql query using Entity framework in MVC / C#

Sql query using entity framework. In the below example we can use sql query or stored procedure or view.

public List<AppointmentDTO> GetAppointmentList()

        {

            logger.InfoFormat("Repository to GetappointmentList :: Start");

            try

            {                

                var apptListResult = context.Database.SqlQuery<AppointmentDTO>("SELECT ID,ApptDate,PatientId From Appointment").ToList();

                logger.InfoFormat("Repository to  GetappointmentList :: End");

                return apptListResult;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat(

                    "Repository - An error occurred while retrieving GetappointmentList. Exception: {0}",

                    ex);

                return null;

            }

        }