I have changed the Type from "Time" to "DateTime" but it rises an exception on Synchronize.
Exception: {"Es ist keine Zuordnung vom DbType-Wert System.TimeSpan zu einem bekannten Wert für SqlCeType vorhanden."}
In English: There is no assignment of DbType value System.TimeSpan available at a known value for SqlCeType.
// Server-Provision
using ( var con = new SqlConnection ( connectionString ) ) {
var readOnlyScope = new DbSyncScopeDescription ( "TerminalReadOnlyScope" );
var scheduleItemTable = SqlSyncDescriptionBuilder.GetDescriptionForTable ( "ScheduleItem", con );
scheduleItemTable.Columns["From"].Type = "datetime"; // Before this, the type was "Time"
readOnlyScope.Tables.Add(scheduleItemTable);
readOnlyScope.Apply ( );
}
// Client-Provision
using ( var serverConn = new SqlConnection ( serverConnectionString ) ) {
using ( var clientConn = new SqlCeConnection ( clientConnectionString ) ) {
var readOnlyScope = SqlSyncDescriptionBuilder.GetDescriptionForScope ( "TerminalReadOnlyScope", serverConn );
var readOnlyProvision = new SqlCeSyncScopeProvisioning ( clientConn, readOnlyScope );
readOnlyProvision.Apply ( );
}
}
// Synchronization
using ( var serverConn = new SqlConnection ( serverConnectionString ) ) {
using ( var clientConn = new SqlCeConnection ( clientConnectionString ) ) {
var readOnlySync = new SyncOrchestrator ( );
readOnlySync.LocalProvider = new SqlCeSyncProvider ( "TerminalReadOnlyScope", clientConn );
readOnlySync.RemoteProvider = new SqlSyncProvider ( "TerminalReadOnlyScope", serverConn );
readOnlySync.Direction = SyncDirectionOrder.Download;
readOnlySync.Synchronize ( );
}
}
