Link to home
Start Free TrialLog in
Avatar of tedatadcu
tedatadcuFlag for Egypt

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


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(),

               };

Open in new window

Avatar of kaufmed
kaufmed
Flag of United States of America image

I faced a problem when I try to view the ResultsView of " _result "
Do you mean you get the problem when trying to view the result in the debugger, or do you get the error during runtime?
Avatar of tedatadcu

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

Open in new window

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 "
ASKER CERTIFIED SOLUTION
Avatar of kaufmed
kaufmed
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks alot really thanks