Convert XML back to relational data - How?

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi all,
I would like to convert an rss xml feed back into a relational data table format.
I would need to do the SELECT based on the pubDate as I would only want the current days rss.
My pseudo-code would be:
INSERT INTO tblRSS("title","description","pubDate")<br/>
SELECT title,description,pubDate FROM myRSSfeed WHERE pubDate = "todays date
Ive being reading on the net that LINQ might be the best way to do this?
Thanks for any help.
Regards<br/>
Melt

View the full article
 
Back
Top