System.Data.SqlClient.MetaType.GetComValueFromSqlVariant C# (CSharp) Méthode

GetComValueFromSqlVariant() static private méthode

static private GetComValueFromSqlVariant ( object sqlVal ) : object
sqlVal object
Résultat object
        internal static object GetComValueFromSqlVariant(object sqlVal)
        {
            object comVal = null;

            if (ADP.IsNull(sqlVal))
                return comVal;

            if (sqlVal is SqlSingle)
                comVal = ((SqlSingle)sqlVal).Value;
            else if (sqlVal is SqlString)
                comVal = ((SqlString)sqlVal).Value;
            else if (sqlVal is SqlDouble)
                comVal = ((SqlDouble)sqlVal).Value;
            else if (sqlVal is SqlBinary)
                comVal = ((SqlBinary)sqlVal).Value;
            else if (sqlVal is SqlGuid)
                comVal = ((SqlGuid)sqlVal).Value;
            else if (sqlVal is SqlBoolean)
                comVal = ((SqlBoolean)sqlVal).Value;
            else if (sqlVal is SqlByte)
                comVal = ((SqlByte)sqlVal).Value;
            else if (sqlVal is SqlInt16)
                comVal = ((SqlInt16)sqlVal).Value;
            else if (sqlVal is SqlInt32)
                comVal = ((SqlInt32)sqlVal).Value;
            else if (sqlVal is SqlInt64)
                comVal = ((SqlInt64)sqlVal).Value;
            else if (sqlVal is SqlDecimal)
                comVal = ((SqlDecimal)sqlVal).Value;
            else if (sqlVal is SqlDateTime)
                comVal = ((SqlDateTime)sqlVal).Value;
            else if (sqlVal is SqlMoney)
                comVal = ((SqlMoney)sqlVal).Value;
            else if (sqlVal is SqlXml)
                comVal = ((SqlXml)sqlVal).Value;
            else
            {
                Debug.Assert(false, "unknown SqlType class stored in sqlVal");
            }


            return comVal;
        }

Usage Example

 private object ValidateBulkCopyVariant(object value)
 {
     switch (MetaType.GetMetaTypeFromValue(value).TDSType)
     {
     case 0xa5:
     case 0xa7:
     case 0xe7:
     case 0x7f:
     case 0x24:
     case 40:
     case 0x29:
     case 0x2a:
     case 0x2b:
     case 0x30:
     case 50:
     case 0x34:
     case 0x38:
     case 0x3b:
     case 60:
     case 0x3d:
     case 0x3e:
     case 0x6c:
         if (value is INullable)
         {
             return(MetaType.GetComValueFromSqlVariant(value));
         }
         return(value);
     }
     throw SQL.BulkLoadInvalidVariantValue();
 }
All Usage Examples Of System.Data.SqlClient.MetaType::GetComValueFromSqlVariant