tedatadcu
asked on
Items Function evaluation timed out.
Hello!
I faced a problem when I try to view the ResultsView of " _result " I can't get the result it showed me this error msg " Items Function evaluation timed out. "
I faced a problem when I try to view the ResultsView of " _result " I can't get the result it showed me this error msg " Items Function evaluation timed out. "
var _result =
from AS_EN in adminStatus_Enalbled
join AS_DI in adminStatus_Disabled on AS_EN.adminStatus_Enalbled_popID equals AS_DI.adminStatus_Disabled_popID
into p
from s in p.DefaultIfEmpty()
select new {
ExchangeMatrixID = AS_EN.adminStatus_Enalbled_popID,
AS_En_Count = (AS_EN != null) ? AS_EN.adminStatus_Enalbled_Count : 0,
AS_Di_Count = (s != null) ? s.adminStatus_Disabled_Count : 0,
OP_UP_Count = (
from OP_UP_Count in OperationalStatus_Up
where OP_UP_Count.OperationalStatus_Up_popID.Equals(AS_EN.adminStatus_Enalbled_popID)
select OP_UP_Count.OperationalStatus_Up_Count).FirstOrDefault(),
};
ASKER
yes, I get the problem when trying to view the result in the debugger !!?
From what I read, this is a flaw (or feature) of the debugger. The solutions point to creating a function to inspect the value of the result. However, let's try a tweak on that. Try the following. I've included the "#if DEBUG" so that the code will only be compiled when you are in a DEBUG configuration. Also, the debugger should break on the subsequent line, and you should be able to inspect the resulting list.
var _result =
from AS_EN in adminStatus_Enalbled
join AS_DI in adminStatus_Disabled on AS_EN.adminStatus_Enalbled_popID equals AS_DI.adminStatus_Disabled_popID
into p
from s in p.DefaultIfEmpty()
select new {
ExchangeMatrixID = AS_EN.adminStatus_Enalbled_popID,
AS_En_Count = (AS_EN != null) ? AS_EN.adminStatus_Enalbled_Count : 0,
AS_Di_Count = (s != null) ? s.adminStatus_Disabled_Count : 0,
OP_UP_Count = (
from OP_UP_Count in OperationalStatus_Up
where OP_UP_Count.OperationalStatus_Up_popID.Equals(AS_EN.adminStatus_Enalbled_popID)
select OP_UP_Count.OperationalStatus_Up_Count).FirstOrDefault(),
};
#if DEBUG
var _resultList = _result.ToList();
System.Diagnostics.Debugger.Break();
#endif
ASKER
Dear kaufmed,
I already can get the result view but it doesn't appear and I get this error msg " Items Function evaluation timed out "
I already can get the result view but it doesn't appear and I get this error msg " Items Function evaluation timed out "
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks alot really thanks