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
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
ASKER
The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.
TRUSTED BY