IMultipleResult.GetResult<>() truncating result data

Question

hi I am calling a stored procedure using Linq2Sql, and the sp returns a long xml string as the result, from a select statment.

I'm using IMultipleResults.GetResult<>() to retrieve the string. Everyting is fine except when the Xml string is too long, and the GetResult returns only a partial output.

Is there any constraint on IMultipleResults.GetResult on long string? Is there a constraint in sql?

Answer 1

Check out this MSDN article. It might be useful.