Sql Server xml column with Entity Framework - how to keep insignificant whitespaces

Sql server 2005 (even 2008) strips the insignificant whitespaces by default. To keep one can use the CONVERT funtction with the last argument as '1' (Ref. Article). How can we do the same thing in Entity Framework?

thanks

Answers


I found a workaround for the problem. You can set the xml attribute 'xml:space=preserve" at the document level. Both Sql server 2005 and 2008 respect the attribute setting and keep the whitespaces. it was a pleasant surprise. Unfortunately, MSDN documentation does not explicitly say this.


Need Your Help

Examining C/C++ Heap memory statistics in gdb

linux gdb malloc heap x86-64

I'm trying to investigate the state of the C/C++ heap from within gdb on Linux amd64, is there a nice way to do this?

Is there any way to avoid the use of my app after removed it from the store?

android ios google-play app-store

I need to unpublish my app from the app store and the play store. If I do, people how downloaded the application may continue using it? Can we prevent this?