I have a very large legacy database I am using and I wanted to use subsonic against the stored procedures.
Everytime I generated, my StoredProcedures.cs remained empty.
A colleague of mine has come across this problem before and found it is because the stored procedures are too big.
If you go to this page of the souce
and line 1745, if I run this query in my database I get the following error:
Msg 1540, Level 16, State 1, Line 1
Cannot sort a row of size 8098, which is greater than the allowable maximum of 8094.
If I remove the orderby from the statement it works.
Is it possible to remove the orderby or is this needed?
Or is there another way round it?