I use LLBLGen 2.5 final released on August 28th 2007. I use self servicing. I have a view having a column body nvarchar(MAX). I get an error when paging.

The size (2147483647) given to the column 'Body' exceeds the maximum allowed for any data type (8000). at System.Data.SqlClient.SqlConnection.OnError...

This happens on pages 2 and above.

Looking at the sql generated by the Dynamic Query Engine:- I can see that for page one it uses the TOP keyword and for other pages it creates a temporary table.

Query: CREATE TABLE #TempTable ([__rowcnt][int] IDENTITY (1,1) NOT NULL,[Id][Int] NULL,[ParentPostId][Int] NULL,[Title]NVarChar NULL,[Body]NVarChar NULL,...

I looked at the forums:-

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=8838&StartAtMessage=0&#48911

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=1051

The forums above where created in January 2007 and the release above is for august 2007.

I use LLBLGen 2.5 final released on August 28th 2007

The most recent release is one year later (Aug 2008 ) than the one you are using, would you please try it first.

Also have you set the appropriate DQE Compatibility mode?

Walaa wrote:

I use LLBLGen 2.5 final released on August 28th 2007

The most recent release is one year later (Aug 2008 ) than the one you are using, would you please try it first.

Also have you set the appropriate DQE Compatibility mode?

I upgraded to 2.6

Thanks Walaa