public static Dictionary <string, SqlTypeInfo> GetTypeMapping() { var dateTimeTypeInfo = new SqlTypeInfo(typeof(DateTime), typeof(DateTime?)); var intTypeInfo = new SqlTypeInfo(typeof(int), typeof(int?)); var byteArrayTypeInfo = new SqlTypeInfo(typeof(byte[])); return(new Dictionary <string, SqlTypeInfo>() { { "int", intTypeInfo }, { "smallint", new SqlTypeInfo(typeof(short), typeof(short?)) }, { "tinyint", new SqlTypeInfo(typeof(byte), typeof(byte?)) }, { "varchar", new SqlTypeInfo(typeof(string)) }, { "nvarchar", new SqlTypeInfo(typeof(string)) }, { "text", new SqlTypeInfo(typeof(string)) }, { "ntext", new SqlTypeInfo(typeof(string)) }, { "xml", new SqlTypeInfo(typeof(string)) }, { "bigint", new SqlTypeInfo(typeof(long), typeof(long?)) }, { "uniqueidentifier", new SqlTypeInfo(typeof(Guid), typeof(Guid?)) }, { "bit", new SqlTypeInfo(typeof(bool), typeof(bool?)) }, { "binary", byteArrayTypeInfo }, { "varbinary", byteArrayTypeInfo }, { "image", byteArrayTypeInfo }, { "decimal", new SqlTypeInfo(typeof(decimal), typeof(decimal?)) }, { "date", dateTimeTypeInfo }, { "smalldatetime", dateTimeTypeInfo }, { "datetime", dateTimeTypeInfo }, { "datetime2", dateTimeTypeInfo }, { "datetimeoffset", new SqlTypeInfo(typeof(DateTimeOffset), typeof(DateTimeOffset?)) }, { "timestamp", byteArrayTypeInfo } }); }
public static Dictionary<string, SqlTypeInfo> GetTypeMapping() { var dateTimeTypeInfo = new SqlTypeInfo(typeof (DateTime), typeof (DateTime?)); var intTypeInfo = new SqlTypeInfo(typeof (int), typeof (int?)); var byteArrayTypeInfo = new SqlTypeInfo(typeof (byte[])); return new Dictionary<string, SqlTypeInfo>() { {"int", intTypeInfo}, {"smallint", new SqlTypeInfo(typeof(short), typeof(short?))}, {"tinyint", new SqlTypeInfo(typeof(byte), typeof(byte?))}, {"varchar", new SqlTypeInfo(typeof (string))}, {"nvarchar", new SqlTypeInfo(typeof (string))}, {"text", new SqlTypeInfo(typeof (string))}, {"ntext", new SqlTypeInfo(typeof (string))}, {"xml", new SqlTypeInfo(typeof (string))}, {"bigint", new SqlTypeInfo(typeof (long), typeof (long?))}, {"uniqueidentifier", new SqlTypeInfo(typeof (Guid), typeof (Guid?))}, {"bit", new SqlTypeInfo(typeof (bool), typeof (bool?))}, {"binary", byteArrayTypeInfo}, {"varbinary", byteArrayTypeInfo}, {"image", byteArrayTypeInfo}, {"decimal", new SqlTypeInfo(typeof (decimal), typeof (decimal?))}, {"date", dateTimeTypeInfo}, {"smalldatetime", dateTimeTypeInfo}, {"datetime", dateTimeTypeInfo}, {"datetime2", dateTimeTypeInfo}, {"datetimeoffset", new SqlTypeInfo(typeof(DateTimeOffset), typeof(DateTimeOffset?))}, {"timestamp", byteArrayTypeInfo} }; }