Hi
I am facing slowness issue when retrieve data via entityframework 6.
It query a table, with return 20 records only. The SQL statement is fast, completed within sec

However, when I use EF code as below, it takes 11-15 secs.

public class EmployeesDTO
    {
        public EmployeesDTO() { }
        public string employeeNo { get; set; }
    }

DbContext dbCtx = new DbContext("connectionstring");
SqlParameter para = new SqlParameter("@yearFor", SqlDbType.Char, 4);
string = "select ....";
para.Value = eaReportConfig.yearFor;
IList<EmployeesDTO> empList = dbCtx.Database.SqlQuery<EmployeesDTO>(sql, para).ToList(); // slowness

//Or

DbRawSqlQuery<EmployeesDTO> empList = dbCtx.Database.SqlQuery<EmployeesDTO>(sql, para);
foreach(EmployeesDTO emp in empList) // slowness
{
}

EmployeesDTO
Any idea? If I use normal ADO.NET code, it is fast.