How to store more than 4k bytes of data in SQL CE 4?

I need to store more than 4k of bytes in my SQLCE 4 database. How can I do that with the ASP.NET Web Pages 1.0?

1: The Microsoft.Data provider fails when I try to populate a parameter with more than 4k bytes.
2: Referencing SqlServerCe assembly and using SqlCeConnection/SqlCeCommand/SqlCeParameter throws exception: SQL Server Compact is not intended for ASP.NET development.

How can I somehow map the generic DbType, which does not have NText as an option, to the ntext column in my database? (SqlCeParameter supports DbSqlType, which has ntext, but see problem #2)

Re: How to store more than 4k bytes of data in SQL CE 4?

You are referenceing the wrong version of System.data.SqlServerCe.dll.

Browse to the one in:

%ProgramFiles%\Microsoft SQL Server Compact Edition\v4.0\Desktop

Then you can use ADO.NET.

Re: How to store more than 4k bytes of data in SQL CE 4?

Thank, that's helpful. For anyone else who need to use ntext on WebMatrix, you can use the following workaround:

SqlCeParameter contentParam = new SqlCeParameter("6", System.Data.SqlDbType.NText);
contentParam.Value = post.Content;
cmd.Parameters.Add(contentParam);

This is also described at the bottom of the beta readme:

http://learn.iis.net/page.aspx/872/webmatrix-beta-release-readme/

PS: The reason why I've been unable to make even the above code work, is that changing from nvarchar to ntext doesn't work, every time I change to next and hit save, it's just reverted back to nvarchar... I didn't notice that until I figured I had to verify it.

Re: How to store more than 4k bytes of data in SQL CE 4?

That seems to be a bug in the Table/Column Designer form. You need to ensure focus is on the top half when you hit save or Ctrl + S (when you can ;o))