c# - No mapping exists from DbType System.DateTimeOffset to a known SqlCeType -

I have a SQL Server 2008 database that includes DateTimeOffset objects according to I,

< P> SQL Server provides support for compacting new data types in compact SQL Server 2008 such as date, time, datetime2, datetimeoffset, geography, and geometry in SQL Server 2008 to copy new data types, nchararchar, Image, etc. are mapped to. For more information about the data types in SQL Server 2008, see the types of SQL Server 2008 books in the online document.

However, when I use the Microsoft Sync Framework and try to synchronize my SQL Server Compact Database, I get the following error:

No mapping exists from the DBTIP system. DataTime Offset for known SqlCeType

The related Microsoft Sync Framework documentation is at SQL CE 3.5SP2 and .NET Framework 4.0.

I am lost here, am I doing wrong?

ADO Which version of Net and Net Compact Framework are you using? And indicate that wrt datetimeoffset

If ADOs If the server provider is hosted on a computer running NET 2.0 SP1, then ADO.NET 2.0 SP1 should also be available for the customer to convert to the conversion of the datetimeoffset on the automatic conversion of the client, Net Compact Framework 2.0 SP1 or .NET Compact Framework 3.5 is not supported.

This corresponds to your error.