208 references to SqlDbType
System.Data (208)
fx\src\data\Microsoft\SqlServer\Server\MetadataUtilsSmi.cs (14)
166metaData.SqlDbType == SqlDbType.Image || 167metaData.SqlDbType == SqlDbType.NText || 168metaData.SqlDbType == SqlDbType.Text || 169metaData.SqlDbType == SqlDbType.Udt; 477return md.SqlDbType != SqlDbType.Structured && 478md.SqlDbType != SqlDbType.Date && 479md.SqlDbType != SqlDbType.DateTime2 && 480md.SqlDbType != SqlDbType.DateTimeOffset && 481md.SqlDbType != SqlDbType.Time; 486if (SqlDbType.Xml == source.SqlDbType) { 488source.SqlDbType, 502source.SqlDbType, 573return firstMd.SqlDbType == secondMd.SqlDbType && 580firstMd.SqlDbType != SqlDbType.Structured && // SqlMetaData doesn't support Structured types
fx\src\data\Microsoft\SqlServer\Server\SmiMetaData.cs (7)
135DefaultChar_NoCollation.SqlDbType, 149DefaultNChar_NoCollation.SqlDbType, 163DefaultNText_NoCollation.SqlDbType, 177DefaultNVarChar_NoCollation.SqlDbType, 191DefaultText_NoCollation.SqlDbType, 205DefaultVarChar_NoCollation.SqlDbType, 785SqlDbType,
fx\src\data\Microsoft\SqlServer\Server\SmiXetterAccessMap.cs (2)
108return __isGetterAccessValid[(int) metaData.SqlDbType, (int) xetterType]; 116return __isSetterAccessValid[(int) metaData.SqlDbType, (int) xetterType];
fx\src\data\Microsoft\SqlServer\Server\SqlDataRecord.cs (1)
196if (_usesStringStorageForXml && SqlDbType.Xml == colMeta.SqlDbType) {
fx\src\data\Microsoft\SqlServer\Server\SqlRecordBuffer.cs (7)
343|| _metadata.SqlDbType == SqlDbType.Money 344|| _metadata.SqlDbType == SqlDbType.NVarChar 345|| _metadata.SqlDbType == SqlDbType.DateTime 346|| _metadata.SqlDbType == SqlDbType.Date 347|| _metadata.SqlDbType == SqlDbType.DateTime2, 370Debug.Assert(value != null && (value.SqlDbType == SqlDbType.Money || value.SqlDbType == SqlDbType.NVarChar),
fx\src\data\Microsoft\SqlServer\Server\ValueUtilsSmi.cs (90)
105length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength * sizeof(char), value.Length, 114(SqlDbType.VarChar == metaData.SqlDbType || 115SqlDbType.NVarChar == metaData.SqlDbType || 116SqlDbType.Char == metaData.SqlDbType || 117SqlDbType.NChar == metaData.SqlDbType)) || 118SqlDbType.Xml == metaData.SqlDbType) { 134CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, 0, fieldOffset, buffer.Length, bufferOffset, length ); 144if (MetaDataUtilsSmi.IsCharOrXmlType(metaData.SqlDbType)) { 145length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength * sizeof(char), actualLength, 149length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, actualLength, fieldOffset, buffer.Length, bufferOffset, length ); 168length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, actualLength, fieldOffset, buffer.Length, bufferOffset, length ); 183length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength * sizeof(char), value.Length, 406if (SqlDbType.Xml == metaData.SqlDbType) { 641else if (SqlDbType.Xml == metaData.SqlDbType) { 724if ((!isDbNull) && (metaData.SqlDbType == SqlDbType.Variant)) { 728if ((metaData.SqlDbType != SqlDbType.Variant) && (!CanAccessGetterDirectly(metaData, ExtendedClrTypeCode.Stream))) { 751if ((!isDbNull) && (metaData.SqlDbType == SqlDbType.Variant)) { 755if ((metaData.SqlDbType != SqlDbType.Variant) && (!CanAccessGetterDirectly(metaData, ExtendedClrTypeCode.TextReader))) { 807switch (metaData.SqlDbType) { 811Debug.Assert(SqlDbType.Variant != metaData.SqlDbType, "Variant-within-variant causes endless recursion!"); 846switch( metaData.SqlDbType ) { 919Debug.Assert( SqlDbType.Variant != metaData.SqlDbType, "Variant-within-variant causes endless recursion!" ); 944if (SqlDbType.Udt == metaData.SqlDbType) { 947result = __typeSpecificNullForSqlValue[(int)metaData.SqlDbType]; 950switch (metaData.SqlDbType) { 954Debug.Assert(SqlDbType.Variant != metaData.SqlDbType, "Variant-within-variant causes endless recursion!"); 986if (SqlDbType.Udt == metaData.SqlDbType) { 990result = __typeSpecificNullForSqlValue[(int)metaData.SqlDbType]; 994switch( metaData.SqlDbType ) { 1067Debug.Assert( SqlDbType.Variant != metaData.SqlDbType, "Variant-within-variant causes endless recursion!" ); 1134if (SqlDbType.Udt == metaData.SqlDbType) { 1138SqlBuffer.StorageType stype = SqlDbTypeToStorageType(metaData.SqlDbType); 1170switch( metaData.SqlDbType ) 1229Debug.Assert( SqlDbType.Variant != metaData.SqlDbType, "Variant-within-variant not supposed to be possible!" ); 1262switch(metaData.SqlDbType) { 1268Debug.Assert( SqlDbType.Variant != metaData.SqlDbType, "Variant-within-variant not supposed to be possible!" ); 1354length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, fieldOffset, buffer.Length, bufferOffset, length ); 1389length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, fieldOffset, buffer.Length, bufferOffset, length ); 1660CanAccessSetterDirectly(metaData, typeCode), "Un-validated type '" + typeCode + "' for metaData: " + metaData.SqlDbType); 1695CanAccessSetterDirectly(metaData, typeCode), "Un-validated type '" + typeCode + "' for metaData: " + metaData.SqlDbType); 1727switch ( metaData[i].SqlDbType ) { 1835Debug.Assert( false, "unsupported DbType:" + metaData[i].SqlDbType.ToString() ); 1853switch (metaData[i].SqlDbType) { 1971ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(metaData[i].SqlDbType, metaData[i].IsMultiValued, o, null, 2027Debug.Assert(false, "unsupported DbType:" + metaData[i].SqlDbType.ToString()); 2047switch (metaData[i].SqlDbType) { 2148Debug.Assert( false, "unsupported DbType:" + metaData[i].SqlDbType.ToString() ); 2169switch (metaData[i].SqlDbType) 2309Debug.Assert(false, "unsupported DbType:" + metaData[i].SqlDbType.ToString()); 2394if (SqlDbType.Decimal == metaData.SqlDbType) { 2398Debug.Assert( SqlDbType.Money == metaData.SqlDbType || 2399SqlDbType.SmallMoney == metaData.SqlDbType, 2400"Unexpected sqldbtype=" + metaData.SqlDbType); 2406if (SqlDbType.Decimal == metaData.SqlDbType || SqlDbType.Variant == metaData.SqlDbType) { 2410Debug.Assert( SqlDbType.Money == metaData.SqlDbType || 2411SqlDbType.SmallMoney == metaData.SqlDbType, 2412"Unexpected sqldbtype=" + metaData.SqlDbType); 2435VerifyDateTimeRange(metaData.SqlDbType, value); 2436SetDateTime_Unchecked(sink, setters, ordinal, ((SqlDbType.Date == metaData.SqlDbType) ? value.Date : value)); 2440VerifyTimeRange(metaData.SqlDbType, value); 2446VerifyDateTimeRange(metaData.SqlDbType, value.Value); 2453VerifyDateTimeRange(metaData.SqlDbType, value); 2459VerifyDateTimeRange(metaData.SqlDbType, value); 2464if (!value.IsNull && SqlDbType.SmallMoney == metaData.SqlDbType) { 2474int length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, buffer.Length, offset, buffer.Length - offset ); 2480int length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, buffer.Length, offset, buffer.Length - offset ); 2488length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, value.Length, offset, value.Length - offset ); 2503length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, checked( (int) bufferLength ), offset, checked( (int) bufferLength ) ); 2538length = CheckXetParameters(metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, NoLengthLimit /* buffer length */, offset, NoLengthLimit /* requested length */ ); 2572length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, checked( (int) bufferLength ), offset, checked( (int) bufferLength ) ); 2586length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, checked( (int) bufferLength ), offset, checked( (int) bufferLength - offset ) ); 2590if (MetaDataUtilsSmi.IsAnsiType(metaData.SqlDbType)) { 2646length = CheckXetParameters(metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, NoLengthLimit /* buffer length */, offset, NoLengthLimit /* requested length */ ); 2650if (MetaDataUtilsSmi.IsAnsiType(metaData.SqlDbType)) { 2678int length = CheckXetParameters(metaData.SqlDbType, metaData.MaxLength, value.Length, 0, NoLengthLimit /* buffer */, offset, NoLengthLimit /* request */); 2693length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, checked( (int) bufferLength ), offset, checked( (int) bufferLength - offset ) ); 2704int length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, stringValue.Length, offset, stringValue.Length - offset ); 2711int length = CheckXetParameters( metaData.SqlDbType, metaData.MaxLength, NoLengthLimit /* actual */, 0, value.Length, offset, checked( value.Length - offset ) ); 2748Debug.Assert( SqlDbType.BigInt <= metaData.SqlDbType && SqlDbType.DateTimeOffset >= metaData.SqlDbType ); 2750bool returnValue = __canAccessGetterDirectly[(int)setterTypeCode, (int)metaData.SqlDbType]; 2768Debug.Assert( SqlDbType.BigInt <= metaData.SqlDbType && SqlDbType.DateTimeOffset >= metaData.SqlDbType ); 2770bool returnValue = __canAccessSetterDirectly[(int)setterTypeCode, (int)metaData.SqlDbType]; 3323Debug.Assert(SqlDbType.Variant == metaData.SqlDbType, "Invalid type. This should be called only when the type is variant."); 3331Debug.Assert(SqlDbType.Variant == metaData.SqlDbType, "Invalid type. This should be called only when the type is variant."); 3553if ( SqlDbType.Variant == metaData.SqlDbType ) { 3579if (SqlDbType.Variant == metaData.SqlDbType) { 3665fieldMetaData.SqlDbType, fieldMetaData.IsMultiValued, cellValue, fieldMetaData.Type,
fx\src\data\System\Data\SqlClient\SqlCommand.cs (8)
1927bool isXmlCapable = (null != md && md.Length == 1 && (md[0].SqlDbType == SqlDbType.NText 1928|| md[0].SqlDbType == SqlDbType.NVarChar 1929|| md[0].SqlDbType == SqlDbType.Xml)); 1933SqlStream sqlBuf = new SqlStream(ds, true /*addByteOrderMark*/, (md[0].SqlDbType == SqlDbType.Xml) ? false : true /*process all rows*/); 6224MetaType mt = MetaType.GetMetaTypeFromSqlDbType(requestMetaData[index].SqlDbType, requestMetaData[index].IsMultiValued); 6252if (value is XmlDataFeed && requestMetaData[index].SqlDbType != SqlDbType.Xml) { 6255ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(requestMetaData[index].SqlDbType, requestMetaData[index].IsMultiValued, value, null /* parameters don't use CLR Type for UDTs */, SmiContextFactory.Instance.NegotiatedSmiVersion); 6269switch(requestMetaData[index].SqlDbType) {
fx\src\data\System\Data\SqlClient\SqlDataReaderSmi.cs (25)
66if ( SqlDbType.Udt == md.SqlDbType ) { 76if (SqlDbType.Udt == _currentMetaData[ordinal].SqlDbType) { 81_currentMetaData[ordinal].SqlDbType, _currentMetaData[ordinal].IsMultiValued).ClassType ; 88if (SqlDbType.Udt == _currentMetaData[ordinal].SqlDbType) { 93_currentMetaData[ordinal].SqlDbType, _currentMetaData[ordinal].IsMultiValued).SqlType ; 153return ValueUtilsSmi.SqlDbTypeToStorageType(valueMetaData.SqlDbType); 233if (metaData.SqlDbType == SqlDbType.Xml) { 554MetaType metaType = MetaType.GetMetaTypeFromSqlDbType(colMetaData.SqlDbType, colMetaData.IsMultiValued); 567if (SqlDbType.Decimal == colMetaData.SqlDbType) { 571else if (SqlDbType.Variant == colMetaData.SqlDbType) { 580schemaRow[ProviderType] = (int) colMetaData.SqlDbType; // SqlDbType 581schemaRow[NonVersionedProviderType] = (int) colMetaData.SqlDbType; // SqlDbType 583if (colMetaData.SqlDbType != SqlDbType.Udt) { 602switch (colMetaData.SqlDbType) { 628if ( SqlDbType.Decimal == colMetaData.SqlDbType || 629SqlDbType.Time == colMetaData.SqlDbType || 630SqlDbType.DateTime2 == colMetaData.SqlDbType || 631SqlDbType.DateTimeOffset == colMetaData.SqlDbType) { 636colMetaData.SqlDbType, colMetaData.IsMultiValued).Scale; 663if ( SqlDbType.Timestamp == colMetaData.SqlDbType ) { 696if ( SqlDbType.Udt == colMetaData.SqlDbType ) { 704if ( SqlDbType.Xml == colMetaData.SqlDbType ) { 860if ((metaData.SqlDbType != SqlDbType.Variant) && (IsCommandBehavior(CommandBehavior.SequentialAccess)) && (!ValueUtilsSmi.IsDBNull(_readerEventSink, _currentColumnValuesV3, ordinal))) { 878if ((metaData.SqlDbType != SqlDbType.Variant) && (IsCommandBehavior(CommandBehavior.SequentialAccess)) && (!ValueUtilsSmi.IsDBNull(_readerEventSink, _currentColumnValuesV3, ordinal))) { 894if (_currentMetaData[ordinal].SqlDbType != SqlDbType.Xml) {
fx\src\data\System\Data\SqlClient\TdsParser.cs (7)
8767MetaType mt = MetaType.GetMetaTypeFromSqlDbType(metaData.SqlDbType, metaData.IsMultiValued); 8780if (SqlDbType.Structured == metaData.SqlDbType && metaData.IsMultiValued) { 8800metaData.SqlDbType, metaData.IsMultiValued, value, null, MSS.SmiContextFactory.KatmaiVersion); 8851switch(metaData.SqlDbType) { 9017Debug.Assert(SqlDbType.Structured == metaData.SqlDbType && metaData.IsMultiValued, 9018"Invalid metadata for TVPs. Type=" + metaData.SqlDbType); 9053if (SqlDbType.Timestamp == md.SqlDbType) {
fx\src\data\System\Data\SqlClient\TdsRecordBufferSetter.cs (2)
42Debug.Assert(SqlDbType.Structured == md.SqlDbType, "Unsupported SqlDbType: " + md.SqlDbType);
fx\src\data\System\Data\SqlClient\TdsValueSetter.cs (45)
66switch(_metaData.SqlDbType) { 100Debug.Assert(false, "PLP-only types shouldn't get to this point. Type: " + _metaData.SqlDbType); 109Debug.Assert(false, "Unexpected SqlDbType: " + _metaData.SqlDbType); 119if (SqlDbType.Variant == _metaData.SqlDbType) { 137if (SqlDbType.Variant == _metaData.SqlDbType) { 179Debug.Assert(!MetaType.GetMetaTypeFromSqlDbType(_metaData.SqlDbType, _metaData.IsMultiValued).IsLong, 180"We're assuming long length types are sent as PLP. SqlDbType = " + _metaData.SqlDbType); 182if (SqlDbType.Variant == _metaData.SqlDbType) { 203Debug.Assert(!MetaType.GetMetaTypeFromSqlDbType(_metaData.SqlDbType, _metaData.IsMultiValued).IsLong, 204"We're assuming long length types are sent as PLP. SqlDbType = " + _metaData.SqlDbType); 206if (SqlDbType.Variant == _metaData.SqlDbType) { 232if (MetaDataUtilsSmi.IsAnsiType(_metaData.SqlDbType)) { 262if (SqlDbType.Variant == _metaData.SqlDbType) { 266Debug.Assert(!MetaType.GetMetaTypeFromSqlDbType(_metaData.SqlDbType, _metaData.IsMultiValued).IsLong, 267"We're assuming long length types are sent as PLP. SqlDbType = " + _metaData.SqlDbType); 292Debug.Assert(!MetaType.GetMetaTypeFromSqlDbType(_metaData.SqlDbType, _metaData.IsMultiValued).IsLong, 293"We're assuming long length types are sent as PLP. SqlDbType = " + _metaData.SqlDbType); 316if (MetaDataUtilsSmi.IsAnsiType(_metaData.SqlDbType)) { 329else if (SqlDbType.Variant == _metaData.SqlDbType) { 330Debug.Assert(null != _variantType && SqlDbType.NVarChar == _variantType.SqlDbType, "Invalid variant type"); 380if (SqlDbType.Variant == _metaData.SqlDbType) { 393if (SqlDbType.Variant == _metaData.SqlDbType) { 406if (SqlDbType.Variant == _metaData.SqlDbType) { 412Debug.Assert(SqlDbType.Money == _variantType.SqlDbType, "Invalid variant type"); 422if (SqlDbType.SmallMoney == _metaData.SqlDbType) { 425else if (SqlDbType.Money == _metaData.SqlDbType) { 439if (SqlDbType.Variant == _metaData.SqlDbType) { 452if (SqlDbType.Variant == _metaData.SqlDbType) { 465if (SqlDbType.Variant == _metaData.SqlDbType) { 481if (SqlDbType.Variant == _metaData.SqlDbType) { 482if ((_variantType != null) && (_variantType.SqlDbType == SqlDbType.DateTime2)) 486else if ((_variantType != null) && (_variantType.SqlDbType == SqlDbType.Date)) 505if (SqlDbType.SmallDateTime == _metaData.SqlDbType) { 511} else if (SqlDbType.DateTime == _metaData.SqlDbType) { 517if (SqlDbType.DateTime2 == _metaData.SqlDbType) { 534if (SqlDbType.Variant == _metaData.SqlDbType) { 551if (SqlDbType.Variant == _metaData.SqlDbType) { 571if (SqlDbType.Variant == _metaData.SqlDbType) { 598(value.SqlDbType == SqlDbType.Money || 599value.SqlDbType == SqlDbType.NVarChar || 600value.SqlDbType == SqlDbType.Date || 601value.SqlDbType == SqlDbType.DateTime || 602value.SqlDbType == SqlDbType.DateTime2 || 603value.SqlDbType == SqlDbType.DateTimeOffset || 604value.SqlDbType == SqlDbType.SmallDateTime