Which datatype and which insertion parameter for large data

Here a field in my data records could pass the limit of 8000 chars of nvarchar, and looking for a quite larger Data-Type, e.g about 9000 chars, Any ideas ? At first I was using NvarChar(8000), after finding some could pass this boundary I used NText to see what will happen next, with Entity Framework seems it could do the job as it's expected without defining any Insert statement and Data Adapter, During the programming the system changed to data Adapter and I should do the job with a Insert command, Now the parameter defined is look like this :

cmdIns.Parameters.Add("@story", SqlDbType.NText, 16, "Story")

it seems that the limitation of 16 will be increased automatically while using EF is used but not with the Data Adapter(And it just insert 16 chars of the data), really don't know (can't remember) Is the test with EF passed even the items larger than 8000 ? If so, I'm curious about the reason.

The situation is deciding the proper Data-Type and it's equivalent working parameter to be used on insertion point of this large data field.

Note : Here SQL Server CE is Used

Edit :

Sorry, I had to go at that time, The Data-type which should be used is NTEXT with no alternative here but defining the **insertion Statement and parameter** is a bit hassle, unfortunately none of the suggested methods could do the desired job similar to the piece which I gave.

without defining the length it will give errors (run-time) !
And Using AddWithValue couldn't use a the DataAdapter and do the insertion in bulk. Maybe I have to place it in another question, but this is a piece of this question, and a working answer here could be the complete one. Any ideas ?

Solution

If I understood your question correctly you should be fine doing something like this, omitting the size as it isn't necessary:

cmdIns.Parameters.Add( new SqlParameter( "story", SqlDbType.NText )
{
    Value = yourVariable;
} );