public SqlCeTypeRegistry(SqlCeDbDriver driver) : base(driver) { //numerics AddType("real", DbType.Single, typeof(Single), SqlDbType.Real); AddType("float", DbType.Double, typeof(Double), SqlDbType.Float); AddType("decimal", DbType.Decimal, typeof(Decimal), SqlDbType.Decimal, args: "({precision},{scale})", aliases: "numeric"); //integers // Note: for int types that do not have direct match in database type set, we assign bigger int type in database // For example, signed byte (CLR sbyte) does not have direct match, so we use 'smallint' to handle it in the database. // For ulong (UInt64) CLR type there's no bigger type, so we handle it using 'bigint' which is signed 64-bit int; as a result there might be overflows // in some cases. AddType("int", DbType.Int32, typeof(int), SqlDbType.Int, clrTypes: new Type[] { typeof(UInt16) }); AddType("smallint", DbType.Int16, typeof(Int16), SqlDbType.SmallInt, clrTypes: new Type[] { typeof(sbyte) }); AddType("tinyint", DbType.Byte, typeof(byte), SqlDbType.TinyInt); AddType("bigint", DbType.Int64, typeof(Int64), SqlDbType.BigInt, clrTypes: new Type[] { typeof(UInt32), typeof(UInt64) }); // Bool AddType("bit", DbType.Boolean, typeof(bool), SqlDbType.Bit); // Strings AddType("nvarchar", DbType.String, typeof(string), SqlDbType.NVarChar, supportsMemo: false, args: "({size})"); AddType("nchar", DbType.StringFixedLength, typeof(string), SqlDbType.NChar, args: "({size})", isDefault: false, clrTypes: new Type[] { typeof(char) }); AddType("varchar", DbType.AnsiString, typeof(string), SqlDbType.VarChar, args: "({size})", isDefault: false); AddType("char", DbType.AnsiStringFixedLength, typeof(string), SqlDbType.Char, args: "({size})", isDefault: false); AddType("ntext", DbType.String, typeof(string), SqlDbType.NText, supportsMemo: true, isDefault: false); AddType("text", DbType.AnsiString, typeof(string), SqlDbType.Text, supportsMemo: true, isDefault: false); // Datetime AddType("datetime", DbType.DateTime, typeof(DateTime), SqlDbType.DateTime); //AddType("date", DbType.Date, typeof(DateTime), SqlDbType.Date, isDefault: false); //AddType("time", DbType.Time, typeof(TimeSpan), SqlDbType.Time); AddType("smalldatetime", DbType.DateTime, typeof(DateTime), SqlDbType.SmallDateTime, isDefault: false); // Binaries var binTypes = new Type[] { typeof(Vita.Common.Binary) }; AddType("varbinary", DbType.Binary, typeof(byte[]), SqlDbType.VarBinary, supportsMemo: false, args: "({size})", clrTypes: binTypes); AddType("binary", DbType.Binary, typeof(byte[]), SqlDbType.Binary, isDefault: false, args: "({size})", clrTypes: binTypes); AddType("image", DbType.Binary, typeof(byte[]), SqlDbType.Image, supportsMemo: true, isDefault: false, clrTypes: binTypes); AddType("uniqueidentifier", DbType.Guid, typeof(Guid), SqlDbType.UniqueIdentifier); AddType("money", DbType.Currency, typeof(Decimal), SqlDbType.Money, isDefault: false); // DateTimeOffset - store it as string and provide converters AddType("nvarchar(40)", DbType.String, typeof(string), SqlDbType.NVarChar, isDefault: false, isSubType: true, clrTypes: new Type[] { typeof(DateTimeOffset) }); Converters.AddConverter <string, DateTimeOffset>(StringToDateTimeOffset, DateTimeOffsetToString); AddType("nvarchar(20)", DbType.String, typeof(string), SqlDbType.NVarChar, isDefault: false, isSubType: true, clrTypes: new Type[] { typeof(TimeSpan) }); Converters.AddConverter <string, TimeSpan>(x => TimeSpan.Parse((string)x), x => ((TimeSpan)x).ToString("G")); // the following types should be treated as auto-memo - whenevery property specifies this type explicitly through [Column(TypeName=?)] spec, // the column is set to Memo (unlimited size) - unless size is specified explicitly. RegisterAutoMemoTypes("image", "ntext", "text"); }
public SqlCeTypeRegistry(SqlCeDbDriver driver) : base(driver) { //numerics AddType("real", DbType.Single, typeof(Single), SqlDbType.Real); AddType("float", DbType.Double, typeof(Double), SqlDbType.Float); AddType("decimal", DbType.Decimal, typeof(Decimal), SqlDbType.Decimal, args: "({precision},{scale})", aliases: "numeric"); //integers // Note: for int types that do not have direct match in database type set, we assign bigger int type in database // For example, signed byte (CLR sbyte) does not have direct match, so we use 'smallint' to handle it in the database. // For ulong (UInt64) CLR type there's no bigger type, so we handle it using 'bigint' which is signed 64-bit int; as a result there might be overflows // in some cases. AddType("int", DbType.Int32, typeof(int), SqlDbType.Int, clrTypes: new Type[] { typeof(UInt16) }); AddType("smallint", DbType.Int16, typeof(Int16), SqlDbType.SmallInt, clrTypes: new Type[] { typeof(sbyte) }); AddType("tinyint", DbType.Byte, typeof(byte), SqlDbType.TinyInt); AddType("bigint", DbType.Int64, typeof(Int64), SqlDbType.BigInt, clrTypes: new Type[] { typeof(UInt32), typeof(UInt64) }); // Bool AddType("bit", DbType.Boolean, typeof(bool), SqlDbType.Bit); // Strings AddType("nvarchar", DbType.String, typeof(string), SqlDbType.NVarChar, supportsMemo: false, args: "({size})"); AddType("nchar", DbType.StringFixedLength, typeof(string), SqlDbType.NChar, args: "({size})", isDefault: false, clrTypes: new Type[] { typeof(char) }); AddType("varchar", DbType.AnsiString, typeof(string), SqlDbType.VarChar, args: "({size})", isDefault: false); AddType("char", DbType.AnsiStringFixedLength, typeof(string), SqlDbType.Char, args: "({size})", isDefault: false); AddType("ntext", DbType.String, typeof(string), SqlDbType.NText, supportsMemo: true, isDefault: false); AddType("text", DbType.AnsiString, typeof(string), SqlDbType.Text, supportsMemo: true, isDefault: false); // Datetime AddType("datetime", DbType.DateTime, typeof(DateTime), SqlDbType.DateTime); //AddType("date", DbType.Date, typeof(DateTime), SqlDbType.Date, isDefault: false); //AddType("time", DbType.Time, typeof(TimeSpan), SqlDbType.Time); AddType("smalldatetime", DbType.DateTime, typeof(DateTime), SqlDbType.SmallDateTime, isDefault: false); // Binaries var binTypes = new Type[] { typeof(Vita.Common.Binary) }; AddType("varbinary", DbType.Binary, typeof(byte[]), SqlDbType.VarBinary, supportsMemo: false, args: "({size})", clrTypes: binTypes); AddType("binary", DbType.Binary, typeof(byte[]), SqlDbType.Binary, isDefault: false, args: "({size})", clrTypes: binTypes); AddType("image", DbType.Binary, typeof(byte[]), SqlDbType.Image, supportsMemo: true, isDefault: false, clrTypes: binTypes); AddType("uniqueidentifier", DbType.Guid, typeof(Guid), SqlDbType.UniqueIdentifier); AddType("money", DbType.Currency, typeof(Decimal), SqlDbType.Money, isDefault: false); // DateTimeOffset - store it as string and provide converters AddType("nvarchar(40)", DbType.String, typeof(string), SqlDbType.NVarChar, isDefault: false, isSubType: true, clrTypes: new Type[] { typeof(DateTimeOffset) }); Converters.AddConverter<string, DateTimeOffset>(StringToDateTimeOffset, DateTimeOffsetToString); AddType("nvarchar(20)", DbType.String, typeof(string), SqlDbType.NVarChar, isDefault: false, isSubType: true, clrTypes: new Type[] { typeof(TimeSpan) }); Converters.AddConverter<string, TimeSpan>(x => TimeSpan.Parse((string)x), x => ((TimeSpan)x).ToString("G")); // the following types should be treated as auto-memo - whenevery property specifies this type explicitly through [Column(TypeName=?)] spec, // the column is set to Memo (unlimited size) - unless size is specified explicitly. RegisterAutoMemoTypes("image", "ntext", "text"); }