Jump to content

xml to other database conversion using c#

dbcrawler's Photo Asked by dbcrawler
Posted Jan 12 2010 06:59 AM
3050 Views
Can xml be converted to other database usin C#????
Tags:
1 Subscribe


1 Reply

0
  Mohammad Elsheimy's Photo Answered by Mohammad Elsheimy Peacock
Posted Mar 05 2010 01:52 PM
OK, if you consider SQL Server as our destination, you will have many ways to accomplish that:
  • you can just add the xml data to a xml field and use XQueries to query about the data
  • you can create your own C# routines that would construct the database from the xml schema, read the data from the xml file (with help from System.Xml.dll), and write the data back to sql server
  • you can use LINQ queries to read the data from the source and write them to the database, and that would take only a few lines
  • you can use the traditional DataSets to read the data from the xml and to push them back to the database (using help of DBDataAdapters)

If that is not so useful for me, try searching for a tool or component that would help. I really don't have an idea about a tool like this.
Regards,
Mohammad Elshiemy
Independent software developer, trainer, and author.
http://JustLikeAMagic.WordPress.com

 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >