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.
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 http://github.com/subsonic/SubSonic-2.0/blob/master/SubSonic/DataProviders/SqlDataProvider.cs
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?
Bex