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() + "'!"); } }