The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

Microsoft SQL Server Compact Edition Data Types Mapping

XPO creates these column types when updating the Microsoft SQL Server Compact Edition database schema and expects them in existing databases.

.NET Type Database Column Type
Boolean bit
Byte tinyint
SByte numeric(3,0)
Char nchar(1)
Decimal numeric(19,4)
Double float
Single real
Int16 smallint
UInt16 numeric(5,0)
Int32 int
UInt32 numeric(10,0)
Int64 bigint
UInt64 numeric(20,0)
Guid uniqueidentifier
String nvarchar
DateTime datetime
TimeSpan float
Byte[] image or varbinary(N)
Unlimited size string ntext
See Also