how to convert Database Hierarchical Data to XML using ASP.net 3.5 and LINQ
- by mahdiahmadirad
hello guys!
i have a table with hierarchical structure. like this:
and table data shown here:
this strategy gives me the ability to have unbounded categories and sub-categories.
i use ASP.net 3.5 SP1 and LINQ and MSSQL Server2005. How to convert it to XML? I can Do it with Dataset Object and ".GetXML()" method. but how to implement it with LINQtoSQL or LINQtoXML??? or if there is another simpler way to perform that? what is your suggestion? the best way? I searched the web but found nothing for .net 3.5 featuers.