Topic: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
When I am calling a stored procedure from asp.net core the following error is coming.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Here is the parameter value is being passed for the execute
But when I execute the same procedure from sqlserver , it is coming very fast. Any idea why it is being showed slow here in asp.net core ? Please any help would be very appreciated.
SqlParameter parEmpID = new SqlParameter("@Employee", employeeIds);
SqlParameter paryearFrom = new SqlParameter("@FromDate", fromDate);
SqlParameter paryearTo= new SqlParameter("@ToDate", toDate);
SqlParameter parType = new SqlParameter("@Attendancetype", attType);
data = _db.AttendanceOverViewModel.FromSql("dbo.goGetEmployeeAttendanceReport @Employee,@FromDate,@ToDate, @Attendancetype",
parEmpID , paryearFrom , paryearTo, parType).ToList();