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}
};
}
