Hello,

I read your article with interest, because I have to solve similar problem recently. Both solutions are interesting, and both were considered when I was going to write this part of my code.

I found some problems with both of them. First: I have potentially very long strings with rich text tags, so I cound not think about a delimiter, which could be used safely. Also, I know that T-SQL is not very efifcient with string processing, and, as I can possibly have handreds of records to save, it would be slow.

Second: XML is great and easy when you have a dataset to save. In my case, I have objects and it means I have to build XML myself. I tried, by the way, and found it is not very quick as well.

So, our team came up with the third solution. Inside my .NET code we build and SQL string to create and populate TEMP tables, based on properties of my objects, using reflection. Then we execute that in SQL Server, and than call stored procedure to process data from temp table (validate, do some calculations and save to real tables)