Union with LINQ to XML

Posted by Ryan Riley on Stack Overflow See other posts from Stack Overflow or by Ryan Riley
Published on 2009-02-02T19:59:41Z Indexed on 2010/05/03 18:48 UTC
Read the original article Hit count: 448

Filed under:

linq-to-xml

|

union

|

c#

|

LINQ

|

openxml-sdk

I need to union two sets of XElements into a single, unique set of elements. Using the .Union() extension method, I just get a "union all" instead of a union. Am I missing something?

var elements = xDocument.Descendants(w + "sdt")
                   .Union(otherDocument.Descendants(w + "sdt")
                   .Select(sdt =>
                       new XElement(
                           sdt.Element(w + "sdtPr")
                               .Element(w + "tag")
                               .Attribute(w + "val").Value,
                           GetTextFromContentControl(sdt).Trim())
                   )
               );

© Stack Overflow or respective owner

Related posts about linq-to-xml

linq to xml query returning a list of all child elements

as seen on Stack Overflow - Search for 'Stack Overflow'
I have got an xml document which looks something like this. <Root> <Info>....</Info> <Info>....</Info> <response>....</response> <warning>....</warning> <Info>....</Info> </Root> How can i write a linqToXML query so that it… >>> More
Converting Data to XML with LINQ to XML

as seen on Internet.com - Search for 'Internet.com'
Sometimes when you have all kinds of data what you really need is XML. LINQ to XML let's you employ functional construction to convert your data into XML. >>> More
LINQ to XML

as seen on Internet.com - Search for 'Internet.com'
Gain an understanding of LINQ (Language Integrated Query) to XML and see why you'll never want to use the DOM again. >>> More
Write XML using best way(Linq To XML or other)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello All I want to write my xml with following format. How can i do it?I am using c# <map borderColor='c5e5b8' fillColor='6a9057' numberSuffix=' Mill.' includeValueInLabels='0' labelSepChar=': ' baseFontSize='9' showFCMenuItem='0' hoverColor='c2bc23' showTitle='0' type='0' showCanvasBorder='0'… >>> More
LINQ to XML vs. XmlReader

as seen on Stack Overflow - Search for 'Stack Overflow'
In my Silverlight application I'm using mostly XmlReader but I'm playing with idea to replace XmlReader implementation with LINQ to XML. What are pros and cons between LINQ to XML and XmlReader in Silverlight? >>> More

Related posts about union

Whether to use UNION or OR in SQL Server Queries

as seen on SQL Server Performance - Search for 'SQL Server Performance'
Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken from the AdventureWorks database… >>> More
SyFy Channel Original Movie Title Generator

as seen on SQL Team - Search for 'SQL Team'
Saw this linked on reddit today and couldn't resist going through all the combinations: create table #pre(name varchar(20))create table #post(name varchar(20), pre varchar(10))insert #pre select 'Dino' union all select'Alien' union all select'Shark' union all select'Raptor' union all select'Tractor' union all select'Arachno' union all select'Cyber' union all select'Robo' union all select'Choco' union all select'Chupa' union all select'Grizzly' union all select'Mega' union all select'Were' union all select'Sabre' union all select'Man' insert #post select 'dactyl'… >>> More
Referencing a union inside a structure using union tag gives incorrect address

as seen on Stack Overflow - Search for 'Stack Overflow'
I had a need to declare a union inside a structure as defined below: struct MyStruct { int m_DataType; DWORD m_DataLen; union theData { char m_Buff [_MAX_PATH]; struct MyData m_myData; } m_Data; }; Initially, I tried accessing the union data as follows… >>> More
SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL

as seen on SQL Authority - Search for 'SQL Authority'
I often see developers trying following syntax while using ORDER BY. SELECT Columns FROM TABLE1 ORDER BY Columns UNION ALL SELECT Columns FROM TABLE2 ORDER BY Columns However the above query will return following error. Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword ‘ORDER’… >>> More
Play Framework: Error getting sequence nextval using H2 in-memory database

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory. I set up a basic unit test: public class ModelTest { @Test public void checkThatIndustriesExist() { running(fakeApplication(inMemoryDatabase()), new Runnable() { public… >>> More