Map relational database to XML in C#

Question

I have an application that needs to map relational database to XML. The issue is that the database structure is given (I cannot change it) and the XML Schema is given (comes from WSDL).

I need to let the user of my application to tell the system that a given column in a table is mapped to a given element in the schema. Then my application needs to crate XMLs based on the database data.

Is there a technology that can help me? is there a C# control for that.

Thanks

peeles · Accepted Answer · 2009-02-01 20:29:53Z

2

XSLT. I think you should dynamically (based on user input) create xslt and transform data from database (dataset?) to xml.

answered Feb 1, 2009 at 20:29

peeles

1351 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marc_s · Accepted Answer · 2009-02-02 06:32:49Z

2

What's your database - SQL Server? You can achieve a lot of XML flexibility with the SELECT .... FOR XML statement in SQL Server (most definitely in 2005 and up).

And if that's not flexible enough, then I'd second "peeles" recommendation - do a SELECT...FOR XML first and transform the output using XSLT.

Marc

answered Feb 2, 2009 at 6:32

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Comments

winwaed · Accepted Answer · 2010-12-20 21:02:05Z

0

Select...For sounds simpler; but LINQ in your C# is probably another option.

answered Dec 20, 2010 at 21:02

winwaed

7,8206 gold badges43 silver badges84 bronze badges

Collectives™ on Stack Overflow

Map relational database to XML in C#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related