Code:
/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / whidbey / NetFXspW7 / ndp / fx / src / Data / System / Data / SqlClient / TdsParameterSetter.cs / 1 / TdsParameterSetter.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //[....] //----------------------------------------------------------------------------- namespace System.Data.SqlClient { using System; using System.Data; using System.Data.SqlTypes; using System.Diagnostics; using Microsoft.SqlServer.Server; // Simple Getter/Setter for structured parameters to allow using common ValueUtilsSmi code. // This is a stand-in to having a true SmiRequestExecutor class for TDS. internal class TdsParameterSetter : SmiTypedGetterSetter { #region Private fields private TdsRecordBufferSetter _target; #if UseSmiForTds private TdsValueSetter _scalarTarget; #endif #endregion #region ctor & control internal TdsParameterSetter(TdsParserStateObject stateObj, SmiMetaData md) { #if UseSmiForTds if (SqlDbType.Structured == md.SqlDbType) { #endif _target = new TdsRecordBufferSetter(stateObj, md); #if UseSmiForTds } else { _scalarTarget = new TdsValueSetter(stateObj, md); } #endif } #endregion #region TypedGetterSetter overrides // Are calls to Get methods allowed? internal override bool CanGet { get { return false; } } // Are calls to Set methods allowed? internal override bool CanSet { get { return true; } } // valid for structured types // This method called for both get and set. internal override SmiTypedGetterSetter GetTypedGetterSetter(SmiEventSink sink, int ordinal) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); return _target; } // Set value to null // valid for all types public override void SetDBNull(SmiEventSink sink, int ordinal) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); #if UseSmiForTds if (SqlDbType.Structured == md.SqlDbType) { #endif _target.EndElements(sink); #if UseSmiForTds } else { _scalarTarget.SetDBNull(); } #endif } #if UseSmiForTds // valid for SqlDbType.Bit public override void SetBoolean(SmiEventSink sink, int ordinal, Boolean value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetBoolean(value); } // valid for SqlDbType.TinyInt public override void SetByte(SmiEventSink sink, int ordinal, Byte value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetByte(value); } // Semantics for SetBytes are to modify existing value, not overwrite // Use in combination with SetLength to ensure overwriting when necessary // valid for SqlDbTypes: Binary, VarBinary, Image, Udt, Xml // (VarBinary assumed for variants) public override int SetBytes(SmiEventSink sink, int ordinal, long fieldOffset, byte[] buffer, int bufferOffset, int length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); return _scalarTarget.SetBytes(fieldOffset, buffer, bufferOffset, length); } public override void SetBytesLength(SmiEventSink sink, int ordinal, long length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetBytesLength(length); } // Semantics for SetChars are to modify existing value, not overwrite // Use in combination with SetLength to ensure overwriting when necessary // valid for character types: Char, VarChar, Text, NChar, NVarChar, NText // (NVarChar and global clr collation assumed for variants) public override int SetChars(SmiEventSink sink, int ordinal, long fieldOffset, char[] buffer, int bufferOffset, int length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); return _scalarTarget.SetChars(fieldOffset, buffer, bufferOffset, length); } public override void SetCharsLength(SmiEventSink sink, int ordinal, long length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetCharsLength(length); } // valid for character types: Char, VarChar, Text, NChar, NVarChar, NText public override void SetString(SmiEventSink sink, int ordinal, string value, int offset, int length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetString(value, offset, length); } // valid for SqlDbType.SmallInt public override void SetInt16(SmiEventSink sink, int ordinal, Int16 value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetInt16(value); } // valid for SqlDbType.Int public override void SetInt32(SmiEventSink sink, int ordinal, Int32 value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetInt32(value); } // valid for SqlDbType.BigInt, SqlDbType.Money, SqlDbType.SmallMoney public override void SetInt64(SmiEventSink sink, int ordinal, Int64 value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetInt64(value); } // valid for SqlDbType.Real public override void SetSingle(SmiEventSink sink, int ordinal, Single value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetSingle(value); } // valid for SqlDbType.Float public override void SetDouble(SmiEventSink sink, int ordinal, Double value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetDouble(value); } // valid for SqlDbType.Numeric (uses SqlDecimal since Decimal cannot hold full range) public override void SetSqlDecimal(SmiEventSink sink, int ordinal, SqlDecimal value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetSqlDecimal(value); } // valid for DateTime & SmallDateTime public override void SetDateTime(SmiEventSink sink, int ordinal, DateTime value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetDateTime(value); } // valid for UniqueIdentifier public override void SetGuid(SmiEventSink sink, int ordinal, Guid value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetGuid(value); } #endif #endregion } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. //------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //[....] //----------------------------------------------------------------------------- namespace System.Data.SqlClient { using System; using System.Data; using System.Data.SqlTypes; using System.Diagnostics; using Microsoft.SqlServer.Server; // Simple Getter/Setter for structured parameters to allow using common ValueUtilsSmi code. // This is a stand-in to having a true SmiRequestExecutor class for TDS. internal class TdsParameterSetter : SmiTypedGetterSetter { #region Private fields private TdsRecordBufferSetter _target; #if UseSmiForTds private TdsValueSetter _scalarTarget; #endif #endregion #region ctor & control internal TdsParameterSetter(TdsParserStateObject stateObj, SmiMetaData md) { #if UseSmiForTds if (SqlDbType.Structured == md.SqlDbType) { #endif _target = new TdsRecordBufferSetter(stateObj, md); #if UseSmiForTds } else { _scalarTarget = new TdsValueSetter(stateObj, md); } #endif } #endregion #region TypedGetterSetter overrides // Are calls to Get methods allowed? internal override bool CanGet { get { return false; } } // Are calls to Set methods allowed? internal override bool CanSet { get { return true; } } // valid for structured types // This method called for both get and set. internal override SmiTypedGetterSetter GetTypedGetterSetter(SmiEventSink sink, int ordinal) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); return _target; } // Set value to null // valid for all types public override void SetDBNull(SmiEventSink sink, int ordinal) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); #if UseSmiForTds if (SqlDbType.Structured == md.SqlDbType) { #endif _target.EndElements(sink); #if UseSmiForTds } else { _scalarTarget.SetDBNull(); } #endif } #if UseSmiForTds // valid for SqlDbType.Bit public override void SetBoolean(SmiEventSink sink, int ordinal, Boolean value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetBoolean(value); } // valid for SqlDbType.TinyInt public override void SetByte(SmiEventSink sink, int ordinal, Byte value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetByte(value); } // Semantics for SetBytes are to modify existing value, not overwrite // Use in combination with SetLength to ensure overwriting when necessary // valid for SqlDbTypes: Binary, VarBinary, Image, Udt, Xml // (VarBinary assumed for variants) public override int SetBytes(SmiEventSink sink, int ordinal, long fieldOffset, byte[] buffer, int bufferOffset, int length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); return _scalarTarget.SetBytes(fieldOffset, buffer, bufferOffset, length); } public override void SetBytesLength(SmiEventSink sink, int ordinal, long length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetBytesLength(length); } // Semantics for SetChars are to modify existing value, not overwrite // Use in combination with SetLength to ensure overwriting when necessary // valid for character types: Char, VarChar, Text, NChar, NVarChar, NText // (NVarChar and global clr collation assumed for variants) public override int SetChars(SmiEventSink sink, int ordinal, long fieldOffset, char[] buffer, int bufferOffset, int length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); return _scalarTarget.SetChars(fieldOffset, buffer, bufferOffset, length); } public override void SetCharsLength(SmiEventSink sink, int ordinal, long length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetCharsLength(length); } // valid for character types: Char, VarChar, Text, NChar, NVarChar, NText public override void SetString(SmiEventSink sink, int ordinal, string value, int offset, int length) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetString(value, offset, length); } // valid for SqlDbType.SmallInt public override void SetInt16(SmiEventSink sink, int ordinal, Int16 value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetInt16(value); } // valid for SqlDbType.Int public override void SetInt32(SmiEventSink sink, int ordinal, Int32 value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetInt32(value); } // valid for SqlDbType.BigInt, SqlDbType.Money, SqlDbType.SmallMoney public override void SetInt64(SmiEventSink sink, int ordinal, Int64 value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetInt64(value); } // valid for SqlDbType.Real public override void SetSingle(SmiEventSink sink, int ordinal, Single value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetSingle(value); } // valid for SqlDbType.Float public override void SetDouble(SmiEventSink sink, int ordinal, Double value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetDouble(value); } // valid for SqlDbType.Numeric (uses SqlDecimal since Decimal cannot hold full range) public override void SetSqlDecimal(SmiEventSink sink, int ordinal, SqlDecimal value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetSqlDecimal(value); } // valid for DateTime & SmallDateTime public override void SetDateTime(SmiEventSink sink, int ordinal, DateTime value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetDateTime(value); } // valid for UniqueIdentifier public override void SetGuid(SmiEventSink sink, int ordinal, Guid value) { Debug.Assert(0==ordinal, "TdsParameterSetter only supports 0 for ordinal. Actual = " + ordinal); _scalarTarget.SetGuid(value); } #endif #endregion } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- PropertyGridDesigner.cs
- WebHeaderCollection.cs
- InvokeMethodActivity.cs
- SafeEventLogWriteHandle.cs
- ObjectStateManagerMetadata.cs
- _CommandStream.cs
- MemberBinding.cs
- ColorDialog.cs
- DataGridViewCellParsingEventArgs.cs
- HttpDebugHandler.cs
- IconBitmapDecoder.cs
- login.cs
- MouseButton.cs
- SRef.cs
- LinkConverter.cs
- ContentHostHelper.cs
- ProfessionalColors.cs
- OptionUsage.cs
- DbProviderFactoriesConfigurationHandler.cs
- EventLogPermissionEntry.cs
- HwndStylusInputProvider.cs
- AtomContentProperty.cs
- connectionpool.cs
- WebBrowserUriTypeConverter.cs
- DataControlButton.cs
- Symbol.cs
- COM2AboutBoxPropertyDescriptor.cs
- HuffCodec.cs
- AssemblyContextControlItem.cs
- RedBlackList.cs
- TypeToken.cs
- IERequestCache.cs
- SchemaImporterExtensionElement.cs
- Msec.cs
- DataGrid.cs
- SocketInformation.cs
- SoapTransportImporter.cs
- Track.cs
- RecordsAffectedEventArgs.cs
- XamlTemplateSerializer.cs
- RegistryPermission.cs
- SqlInternalConnectionTds.cs
- Size.cs
- StateManager.cs
- ScrollProperties.cs
- Events.cs
- DatagridviewDisplayedBandsData.cs
- HandleValueEditor.cs
- DivideByZeroException.cs
- RichTextBoxAutomationPeer.cs
- RuntimeIdentifierPropertyAttribute.cs
- PartitionResolver.cs
- ImpersonateTokenRef.cs
- Facet.cs
- VideoDrawing.cs
- NotFiniteNumberException.cs
- WinFormsComponentEditor.cs
- Compiler.cs
- SystemIPGlobalStatistics.cs
- TokenBasedSet.cs
- AssemblyInfo.cs
- StaticExtensionConverter.cs
- TimelineGroup.cs
- DiscoveryDocumentLinksPattern.cs
- CacheDependency.cs
- Attachment.cs
- Stylesheet.cs
- DataGridViewCellConverter.cs
- UIElementAutomationPeer.cs
- MenuEventArgs.cs
- TimeSpan.cs
- ObjectStateEntryOriginalDbUpdatableDataRecord.cs
- ApplicationServiceHelper.cs
- HttpChannelBindingToken.cs
- MemberRelationshipService.cs
- SmiXetterAccessMap.cs
- DynamicMethod.cs
- SqlTriggerAttribute.cs
- BookmarkEventArgs.cs
- TagElement.cs
- SamlSecurityToken.cs
- RowToFieldTransformer.cs
- FormConverter.cs
- Scalars.cs
- XmlSchemaGroupRef.cs
- XmlCodeExporter.cs
- ObfuscationAttribute.cs
- JoinSymbol.cs
- _SslState.cs
- ObjectListSelectEventArgs.cs
- XmlWrappingReader.cs
- DataGridViewCellStyleChangedEventArgs.cs
- StringSource.cs
- WebCategoryAttribute.cs
- XamlInterfaces.cs
- Process.cs
- BamlTreeNode.cs
- SiteMapNode.cs
- SamlAssertionKeyIdentifierClause.cs
- WebServiceParameterData.cs