Microsoft Sync framework issue, Data not synced fully for a SqlDbType.Text field
I have a table with one of its column ADDRESS
开发者_运维问答 with datatype Text
. When I sync the data from client to sever all other column values sync properly but only first 16 characters get synced for ADDRESS
column .
I checked in Data access layer of my sync application , Both ApplyInsert
and ApplyUpdate
command parameters have the size of 1000 for that field.
SAMPLE_TABLEApplyInsertCmd.Parameters.Add("@ASC_ADDRESS", SqlDbType.Text, 1000);
and
SAMPLE_TABLEApplyUpdateCmd.Parameters.Add("@ASC_ADDRESS", SqlDbType.Text, 1000);
In ApplyInsert and ApplyUpdate the parameter specified as
@ASC_ADDRESS Text=NULL
Can anyone see and suggest what i have done wrong ?
精彩评论