Pass XML from C# to SQL Server

Question

I'm trying to send XML in following format from C# (DataType string) to SQL Server stored proc:

<Content> </Content>

There is a space which should get stored as it is in SQL Server column. But it gets stored like <Content/>. So in nutshell there is loss of space from c# to SQL Server.

Is there anyway I can avoid this?

I think your sample code got lost, please edit question so we can help you. — Fischermaen
– Fischermaen, Commented Nov 16, 2011 at 6:40
Mayur put some code. It help peers to understand problem better — Pankaj Upadhyay
– Pankaj Upadhyay, Commented Nov 16, 2011 at 6:40
He's losing a space ' ' character in the <content> element — Jim H.
– Jim H., Commented Nov 16, 2011 at 6:40

Randolpho · Accepted Answer · 2011-11-16 06:40:13Z

2

The two fragments are equivalent; SQL server is just optimizing the XML.

Is there a particular reason you need the space in there? If so, you might try xml:space="preserve", like so:

<Content xml:space="preserve"> </Content>

answered Nov 16, 2011 at 6:40

Randolpho

56.5k18 gold badges153 silver badges182 bronze badges

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

Comments

Fischermaen · Accepted Answer · 2011-11-16 06:43:19Z

1

You can add an attribute xml:space="preserve". That helps in "normal" serialization context, I don't know if it will help you in your special context.

answered Nov 16, 2011 at 6:43

Fischermaen

12.5k2 gold badges43 silver badges56 bronze badges

Comments

Alexander Mavrinsky · Accepted Answer · 2011-11-16 06:42:15Z

0

have you tried to use <!CDATA[ ]>?

edited Nov 16, 2011 at 6:42

answered Nov 16, 2011 at 6:41

Alexander Mavrinsky

4653 silver badges7 bronze badges

Collectives™ on Stack Overflow

Pass XML from C# to SQL Server

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