internal static bool IsValidSQLDataType(nHydrate.DataImport.SqlNativeTypes nativeType)
{
switch (nativeType)
{
case SqlNativeTypes.bigint:
case SqlNativeTypes.binary:
case SqlNativeTypes.bit:
case SqlNativeTypes.@char:
case SqlNativeTypes.date:
case SqlNativeTypes.datetime:
case SqlNativeTypes.datetime2:
case SqlNativeTypes.datetimeoffset:
case SqlNativeTypes.@decimal:
case SqlNativeTypes.@float:
//SqlNativeTypes.geography
//SqlNativeTypes.geometry
//SqlNativeTypes.hierarchyid
case SqlNativeTypes.image:
case SqlNativeTypes.@int:
case SqlNativeTypes.money:
case SqlNativeTypes.nchar:
case SqlNativeTypes.ntext:
case SqlNativeTypes.numeric:
case SqlNativeTypes.nvarchar:
case SqlNativeTypes.real:
case SqlNativeTypes.smalldatetime:
case SqlNativeTypes.smallint:
case SqlNativeTypes.smallmoney:
case SqlNativeTypes.sql_variant:
//SqlNativeTypes.sysname
case SqlNativeTypes.text:
case SqlNativeTypes.time:
case SqlNativeTypes.timestamp:
case SqlNativeTypes.tinyint:
//case SqlNativeTypes.:
case SqlNativeTypes.uniqueidentifier:
case SqlNativeTypes.varbinary:
case SqlNativeTypes.varchar:
//case SqlNativeTypes.:
case SqlNativeTypes.xml:
return(true);
default:
return(false);
}
}
private static SqlDbType GetSQLDataType(nHydrate.DataImport.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() + "'!");
}
}
