У меня есть следующий XML
<InvestmentAccount Id="Element01_Source3_Sequqence002" Type="Standard" InvestmentStrategyId="Employer" ParameterOverrideIds="AllocationRateOverride">
<Investment FundName="Fund032" FundValue="4754.82" />
<Investment FundName="Fund034" FundValue="4643.48" />
<Investment FundName="Fund035" FundValue="2509.46" />
<Investment FundName="Fund038" FundValue="7104.71" />
<Investment FundName="Fund042" FundValue="4244.08" />
</InvestmentAccount>
<InvestmentAccount Id="Element01_Source4_Sequence003" Type="DWPRebate" InvestmentStrategyId="DSS" ParameterOverrideIds="DWPAllocationRateOverride">
<Investment FundName="Fund032" FundValue="1881.76" />
<Investment FundName="Fund034" FundValue="1584.18" />
<Investment FundName="Fund035" FundValue="872.99" />
<Investment FundName="Fund038" FundValue="2899.53" />
<Investment FundName="Fund042" FundValue="1762.62" />
</InvestmentAccount>
<InvestmentAccount Id="Element01_Source2_Sequence001" Type="Standard" InvestmentStrategyId="Employee" ParameterOverrideIds="AllocationRateOverride">
<Investment FundName="Fund032" FundValue="7395.91" />
<Investment FundName="Fund034" FundValue="7222.72" />
<Investment FundName="Fund035" FundValue="3903.52" />
<Investment FundName="Fund038" FundValue="11051.32" />
<Investment FundName="Fund042" FundValue="6602.54" />
</InvestmentAccount>
<InvestmentAccount Id="Element02_Source2_Sequence004" Type="TransferNonPR" InvestmentStrategyId="Employee" ParameterOverrideIds="AllocationRateOverride">
<Investment FundName="Fund032" FundValue="1439.29" />
<Investment FundName="Fund034" FundValue="1614.31" />
<Investment FundName="Fund035" FundValue="863.68" />
<Investment FundName="Fund038" FundValue="2153.80" />
<Investment FundName="Fund042" FundValue="1306.45" />
</InvestmentAccount>
<InvestmentAccount Id="Element03_Source2_Sequence005" Type="TransferNonPR" InvestmentStrategyId="Employee" ParameterOverrideIds="AllocationRateOverride">
<Investment FundName="Fund032" FundValue="9617.42" />
<Investment FundName="Fund034" FundValue="10787.03" />
<Investment FundName="Fund035" FundValue="5771.18" />
<Investment FundName="Fund038" FundValue="14391.20" />
<Investment FundName="Fund042" FundValue="8729.81" />
<Investment FundName="fictiousextra" FundValue="1414" />
</InvestmentAccount>
Что я хотел бы сделать, так это то, что InvestmentStrategyId AND Type такие же, как и в случае с последними двумя выше (переупорядочить для ясности), где FundName такое же, как мне нужно суммировать значения фонда. В этом случае с каждой стороны одинаковые, но с каждой стороны может быть больше или меньше.
Итак, в результате мне нужен доступ к FundName и либо FundValue, либо я могу суммировать или уже суммировать значение.
Помощь!
Вот именно этого результата я и пытаюсь добиться.
<InvestmentAccount Id="Element01_Source3_Sequence002" Type="Standard" InvestmentStrategyId="Employer" ParameterOverrideIds="AllocationRateOverride">
<Investment FundName="Fund032" FundValue="4754.82" />
<Investment FundName="Fund034" FundValue="4643.48" />
<Investment FundName="Fund035" FundValue="2509.46" />
<Investment FundName="Fund038" FundValue="7104.71" />
<Investment FundName="Fund042" FundValue="4244.08" />
</InvestmentAccount>
<InvestmentAccount Id="Element01_Source4_Sequence003" Type="DWPRebate" InvestmentStrategyId="DSS" ParameterOverrideIds="DWPAllocationRateOverride">
<Investment FundName="Fund032" FundValue="1881.76" />
<Investment FundName="Fund034" FundValue="1584.18" />
<Investment FundName="Fund035" FundValue="872.99" />
<Investment FundName="Fund038" FundValue="2899.53" />
<Investment FundName="Fund042" FundValue="1762.62" />
</InvestmentAccount>
<InvestmentAccount Id="Element01_Source2_Sequence001" Type="Standard" InvestmentStrategyId="Employee" ParameterOverrideIds="AllocationRateOverride">
<Investment FundName="Fund032" FundValue="7395.91" />
<Investment FundName="Fund034" FundValue="7222.72" />
<Investment FundName="Fund035" FundValue="3903.52" />
<Investment FundName="Fund038" FundValue="11051.32" />
<Investment FundName="Fund042" FundValue="6602.54" />
</InvestmentAccount>
<!-- THIS ONE IS THE SUMMED COMBINTION DUE TO InvestmentStrategyId and Type being multiply occuring -->
<InvestmentAccount ...>
<Investment FundName="Fund032" FundValue="11056.71" />
<Investment FundName="Fund034" FundValue="12401.34" />
<Investment FundName="Fund035" FundValue="6634.86" />
<Investment FundName="Fund038" FundValue="16545" />
<Investment FundName="Fund042" FundValue="10036.26" />
<Investment FundName="fictiousextra" FundValue="1414" />
</InvestmentAccount>
Включая любые имена FundName, которые присутствуют в 1 и отсутствуют в другом.
Я должен добавить, что использую .net 4.0.