internal static SqlDbType GetSQLDataType(SqlNativeTypes nativeType)
{
switch (nativeType)
{
case SqlNativeTypes.bigint: return(SqlDbType.BigInt);
case SqlNativeTypes.binary: return(SqlDbType.Binary);
case SqlNativeTypes.bit: return(SqlDbType.Bit);
case SqlNativeTypes.@char: return(SqlDbType.Char);
case SqlNativeTypes.date: return(SqlDbType.Date);
case SqlNativeTypes.datetime: return(SqlDbType.DateTime);
case SqlNativeTypes.datetime2: return(SqlDbType.DateTime2);
case SqlNativeTypes.datetimeoffset: return(SqlDbType.DateTimeOffset);
case SqlNativeTypes.@decimal: return(SqlDbType.Decimal);
case SqlNativeTypes.@float: return(SqlDbType.Float);
//SqlNativeTypes.geography
//SqlNativeTypes.geometry
//SqlNativeTypes.hierarchyid
case SqlNativeTypes.image: return(SqlDbType.Image);
case SqlNativeTypes.@int: return(SqlDbType.Int);
case SqlNativeTypes.money: return(SqlDbType.Money);
case SqlNativeTypes.nchar: return(SqlDbType.NChar);
case SqlNativeTypes.ntext: return(SqlDbType.NText);
case SqlNativeTypes.numeric: return(SqlDbType.Decimal);
case SqlNativeTypes.nvarchar: return(SqlDbType.NVarChar);
case SqlNativeTypes.real: return(SqlDbType.Real);
case SqlNativeTypes.smalldatetime: return(SqlDbType.SmallDateTime);
case SqlNativeTypes.smallint: return(SqlDbType.SmallInt);
case SqlNativeTypes.smallmoney: return(SqlDbType.SmallMoney);
case SqlNativeTypes.sql_variant: return(SqlDbType.Structured);
//SqlNativeTypes.sysname
case SqlNativeTypes.text: return(SqlDbType.Text);
case SqlNativeTypes.time: return(SqlDbType.Time);
case SqlNativeTypes.timestamp: return(SqlDbType.Timestamp);
case SqlNativeTypes.tinyint: return(SqlDbType.TinyInt);
//case SqlNativeTypes.: return SqlDbType.Udt;
case SqlNativeTypes.uniqueidentifier: return(SqlDbType.UniqueIdentifier);
case SqlNativeTypes.varbinary: return(SqlDbType.VarBinary);
case SqlNativeTypes.varchar: return(SqlDbType.VarChar);
//case SqlNativeTypes.: return SqlDbType.Variant;
case SqlNativeTypes.xml: return(SqlDbType.Xml);
default: throw new Exception("Unknown native SQL type '" + nativeType.ToString() + "'!");
}
}
internal static SqlDbType GetSQLDataType(SqlNativeTypes nativeType)
{
switch (nativeType)
{
case SqlNativeTypes.bigint: return SqlDbType.BigInt;
case SqlNativeTypes.binary: return SqlDbType.Binary;
case SqlNativeTypes.bit: return SqlDbType.Bit;
case SqlNativeTypes.@char: return SqlDbType.Char;
case SqlNativeTypes.date: return SqlDbType.Date;
case SqlNativeTypes.datetime: return SqlDbType.DateTime;
case SqlNativeTypes.datetime2: return SqlDbType.DateTime2;
case SqlNativeTypes.datetimeoffset: return SqlDbType.DateTimeOffset;
case SqlNativeTypes.@decimal: return SqlDbType.Decimal;
case SqlNativeTypes.@float: return SqlDbType.Float;
//SqlNativeTypes.geography
//SqlNativeTypes.geometry
//SqlNativeTypes.hierarchyid
case SqlNativeTypes.image: return SqlDbType.Image;
case SqlNativeTypes.@int: return SqlDbType.Int;
case SqlNativeTypes.money: return SqlDbType.Money;
case SqlNativeTypes.nchar: return SqlDbType.NChar;
case SqlNativeTypes.ntext: return SqlDbType.NText;
case SqlNativeTypes.numeric: return SqlDbType.Decimal;
case SqlNativeTypes.nvarchar: return SqlDbType.NVarChar;
case SqlNativeTypes.real: return SqlDbType.Real;
case SqlNativeTypes.smalldatetime: return SqlDbType.SmallDateTime;
case SqlNativeTypes.smallint: return SqlDbType.SmallInt;
case SqlNativeTypes.smallmoney: return SqlDbType.SmallMoney;
case SqlNativeTypes.sql_variant: return SqlDbType.Structured;
//SqlNativeTypes.sysname
case SqlNativeTypes.text: return SqlDbType.Text;
case SqlNativeTypes.time: return SqlDbType.Time;
case SqlNativeTypes.timestamp: return SqlDbType.Timestamp;
case SqlNativeTypes.tinyint: return SqlDbType.TinyInt;
//case SqlNativeTypes.: return SqlDbType.Udt;
case SqlNativeTypes.uniqueidentifier: return SqlDbType.UniqueIdentifier;
case SqlNativeTypes.varbinary: return SqlDbType.VarBinary;
case SqlNativeTypes.varchar: return SqlDbType.VarChar;
//case SqlNativeTypes.: return SqlDbType.Variant;
case SqlNativeTypes.xml: return SqlDbType.Xml;
default: throw new Exception("Unknown native SQL type '" + nativeType.ToString() + "'!");
}
}