My guess would be the data type of the parameter, depending on the expression you are using in the query.

>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.