I need to save a long XML string in SQL Server 2012. Currently I hold in the \[code\]EDMX\[/code\] and the database a string variable and a string column.
Problem is that my XML string can be very long (> 5000 characters) What is the best practice to handle this variable (both in C# and in SQL Server)? What are the benefits of using XML column?
Problem is that my XML string can be very long (> 5000 characters) What is the best practice to handle this variable (both in C# and in SQL Server)? What are the benefits of using XML column?