calling a SP which returns a long select return using LINQ

Question

I am calling a SP using linq and the SP returns a very long string. but when i receive the string its truncated. is there any way to increase the return length in linq?

Answer 1

This may not be an issue with LINQ to SQL. It may have to do with how you declared the variable containing the output of the stored procedure inside the sproc itself.

Another possibility could be that stored procedure variable was changed after your DBML and entity classes where created. In other words, you could have varchar(100) in your LINQ and varchar(200) in your stored proc. If this is the case, you need to regenerate your DBML.

Answer 2

well, the sp returns the full string, it doesnt turncate.. its only when i call the sp using linq