Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / whidbey / netfxsp / ndp / fx / src / Data / System / Data / SqlClient / TdsParameterSetter.cs / 4 / 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
- ToolStripPanelRenderEventArgs.cs
- EntityParameter.cs
- MenuAutomationPeer.cs
- SQLDecimal.cs
- TimeoutException.cs
- EventDescriptor.cs
- CodeCommentStatementCollection.cs
- RefreshPropertiesAttribute.cs
- SmtpMail.cs
- RichTextBoxAutomationPeer.cs
- SqlProviderServices.cs
- InfoCardRSAPKCS1KeyExchangeFormatter.cs
- HostExecutionContextManager.cs
- RemotingConfigParser.cs
- SemanticResolver.cs
- EditCommandColumn.cs
- ParameterEditorUserControl.cs
- RuleValidation.cs
- WriteStateInfoBase.cs
- LingerOption.cs
- HtmlInputControl.cs
- RemoteWebConfigurationHostServer.cs
- GeneralTransform3DTo2DTo3D.cs
- AttachedPropertyBrowsableAttribute.cs
- ConfigXmlText.cs
- IdentityModelStringsVersion1.cs
- AgileSafeNativeMemoryHandle.cs
- BulletedListEventArgs.cs
- SubqueryTrackingVisitor.cs
- ZipIOModeEnforcingStream.cs
- GridViewSortEventArgs.cs
- EntityContainerEmitter.cs
- DecimalKeyFrameCollection.cs
- Enum.cs
- SendMailErrorEventArgs.cs
- SmtpException.cs
- cache.cs
- TextServicesCompartmentContext.cs
- PermissionSetTriple.cs
- EntityContainer.cs
- DetailsViewPagerRow.cs
- ControlPaint.cs
- MatrixCamera.cs
- CodeTypeReference.cs
- PreviewPageInfo.cs
- CompilationSection.cs
- CompilerWrapper.cs
- MemberListBinding.cs
- ObjectStateEntry.cs
- EventHandlersStore.cs
- WindowsToolbar.cs
- WindowsListViewItemStartMenu.cs
- MenuCommand.cs
- XPSSignatureDefinition.cs
- HashUtility.cs
- SiteMapNodeItemEventArgs.cs
- sqlinternaltransaction.cs
- PhysicalFontFamily.cs
- TypeForwardedFromAttribute.cs
- ApplicationSecurityManager.cs
- QueryPageSettingsEventArgs.cs
- TimeSpanMinutesOrInfiniteConverter.cs
- HttpWebRequest.cs
- StructuredTypeEmitter.cs
- DeadCharTextComposition.cs
- ToolStripGrip.cs
- SoapInteropTypes.cs
- DescendantBaseQuery.cs
- Grant.cs
- UnlockInstanceCommand.cs
- parserscommon.cs
- LicenseException.cs
- Constants.cs
- LayoutEditorPart.cs
- TaiwanLunisolarCalendar.cs
- NetStream.cs
- CodeIdentifier.cs
- ScriptReferenceEventArgs.cs
- DefaultEventAttribute.cs
- ListViewItem.cs
- DecimalAnimationBase.cs
- BamlLocalizableResource.cs
- EraserBehavior.cs
- MimeWriter.cs
- DesignerActionList.cs
- BamlRecordWriter.cs
- EntityStoreSchemaGenerator.cs
- Events.cs
- GradientSpreadMethodValidation.cs
- StateMachineHelpers.cs
- EntityModelSchemaGenerator.cs
- IdnElement.cs
- XamlSerializerUtil.cs
- EncryptedReference.cs
- AuthenticationSection.cs
- UncommonField.cs
- TextElementCollectionHelper.cs
- Line.cs
- ImageListStreamer.cs
- VarRefManager.cs