Sync Services Ado.net SyncSchema

Question

hi I'm trying to build a custom ServerSyncProvider right now I'm trying to understand the GetScema Method

I'm trying to build a dataSet and associate it to SyncSchema class one of my table columns is a nvarchar(50) so im doing this:

DataColumn column = new DataColumn();

        column.ColumnName = "Name";

        column.DataType = typeof(String);

        column.MaxLength = 55;

        table.Columns.Add(column);

but turns out that on my client side, this column becomes nvarchar(1) any idea? tks a lot

Answer 1

Try this:

column.ExtendedProperties.Add("ColumnLength", 50);