score:1
I had forgotten to update this with an answer, but given @EthanTowne's comment, I dug up what I'm doing in this code now:
var o = from ords in cfg.db.OsGetUserOrders(userid)
select ords.XML_F52E5B62_58B1_21e2_B105_00805A49AB12;
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<orders>{0}</orders>", string.Join("", o.ToArray()));
XElement xe = XElement.Parse(sb.ToString());
Basically, the stored proc returns several order
elements, and this code coverts them to an array then joins them into a string. Then I parse it into an XElement. There's probably a better way, and I'm open to other solutions.
Source: stackoverflow.com
Related Query
- How to read large XML RAW from Linq to SQL?
- How to read data from xml file using linq to xml?
- How to read data with pagination from large xml file using c#
- How to read specific field value from xml using linq in C#
- How are people unit testing code that uses Linq to SQL
- How to return anonymous type from c# method that uses LINQ to SQL
- how to see generated sql from a linq query
- How to write linq query to match SQL like select top 100 * from tab?
- How to understand the following C# linq code of implementing the algorithm to return all combinations of k elements from n
- Linq to SQL - How to sort results from query
- How to move from LINQ to SQL to "LINQ to WCF"?
- How to pass LinQ Expressions from F# to C# code
- How to read File names recursively from subfolder using LINQ
- How to read XML file using System.IO.Stream with LINQ
- How can I achieve SQL CASE statement from LINQ
- How do I preserve whitespace characters when parsing XML from C# LINQ
- How does linq actually execute the code to retrieve data from the data source?
- How to set Sql DateTime to null from LINQ
- How do i get all "properties" from xml via linq to xml
- How to Bind Exclude more than one property from a model with linq to sql asp.net mvc
- How do i prevent Linq from adding a GUID so that SQL server can do it?
- How to code the partial extensions that Linq to SQL autogenerates?
- How to get strongly-typed collection from XML using Linq
- How to get SQL query into LINQ form in C# code
- how to get value from xml by Linq
- creating Linq to sqlite dbml from DbLinq source code
- How do i convert this linq code to inline sql
- Read from xml file to objectlist using Linq
- How can I use Linq to build a c# object from xml where an element has zero or more elements of the same type?
- C# LINQ How to get a data source from a db?
More Query from same tag
- Using linq to return an object with a list<object> member
- Refactoring LINQ query
- Problem in populating list object in a certain way
- EF6 Navigation Properties map empty collection instead of null
- EF query using extension method inside extension method
- c# group by alphabets
- Better one from ExecuteQuery and ExecuteCommand in Linq
- LINQ to create list of strings from indexes stored in int[]
- LINQ - Left Join And Group By
- Storing Google map iframe to ASP.net MVC Application without security risks
- Clean Way to Merge Two Typed C# Objects Based on Given Sequence
- Please help with a dictionary comprehension in LINQ, C#
- OR condition with ON clause in join in LINQ
- Show null results through the LEFT JOIN with Linq
- What's the difference between these LINQ queries?
- How to specify the type of an anonymous type while using a generic type
- Empty namespace using Linq Xml
- How to modify type parameter of Expression<Func<???, bool>>?
- Getting Max Value Generic List For Each Item
- Entity Framework, Code First and Full Text Search
- Update Property in List of objects based from a list of ids
- How to do convert the following ino lambda expression(method syntax)?
- Fetch vs FetchMany in NHibernate Linq provider
- XML Response to Linq
- Entity Framework filter nested collection
- LINQ query fails for NULL values
- Best way to write lingq for loop queries
- Filter a list based on a multiple options
- C# - Dynamic Linq left outer join on multiple properties
- How can I retrieve the value for the attribute from an XML file using lambda expressions?