c# - 不存在从 DbType System.DateTimeOffset 到已知 SqlCeType 的映射

Question

我有一个包含 DateTimeOffset 对象的 SQL Server 2008 数据库。根据 this page ,

SQL Server Compact provides support for replicating the new data types in SQL Server 2008 such as date, time, datetime2, datetimeoffset, geography, and geometry. The new data types in SQL Server 2008 are mapped to nchar, nvarchar, image, etc. For more information about data types in SQL Server 2008, see Data Types in SQL Server 2008 Books Online Documentation.

但是，当我使用 Microsoft Sync Framework 并尝试将我的 SQL Server 数据库同步到 SQL Server Compact 数据库时，我收到以下错误:

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

相关的 Microsoft Sync Framework 文档是 here .我正在使用 SQL CE 3.5 SP2 和 .NET Framework 4.0。

我有点迷路了。我做错了什么？

Answer 1

您使用的是什么版本的 ADO.NET 和 .Net Compact Framework？ docs for Sync FW v2.0和 v2.1指示 wrt datetimeoffset

If the server provider is hosted on a computer that is running ADO.NET 2.0 SP1, ADO.NET 2.0 SP1 must also be available on the client for conversion to succeed. Automatic conversion of datetimeoffset on the client is not supported by .NET Compact Framework 2.0 SP1 or .NET Compact Framework 3.5.

这与你的错误一致。