SQLUtility.cs source code in C# .NET

                        
Code:
                         / 4.0 / 4.0 / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / Data / System / Data / SQLTypes / SQLUtility.cs / 1305376 / SQLUtility.cs
                        

                        
                            //------------------------------------------------------------------------------ 
// 
//     Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// junfang 
// [....]
// [....] 
//----------------------------------------------------------------------------- 

//************************************************************************* 
// @File: SQLUtility.cs
//
// Create by:	JunFang
// 
// Purpose: Implementation of utilities in COM+ SQL Types Library.
//			Includes interface INullable, exceptions SqlNullValueException 
//			and SqlTruncateException, and SQLDebug class. 
//
// Notes: 
//
// History:
//
//   09/17/99  JunFang	Created and implemented as first drop. 
//
// @EndHeader@ 
//************************************************************************* 

using System; 
using System.Data.Sql;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Globalization; 
using System.Runtime.Serialization;
 
namespace System.Data.SqlTypes { 

    internal enum EComparison { 
        LT,
        LE,
        EQ,
        GE, 
        GT,
        NE 
    } 

 	// This enumeration is used to inquire about internal storage of a SqlBytes or SqlChars instance: 
    public enum StorageState {
		Buffer = 0,
		Stream = 1,
#if WINFSFunctionality 
		UnmanagedBuffer = 2,
 		Delayed = 3 
#else 
		UnmanagedBuffer = 2
#endif 
 	}

    [Serializable]
    public class SqlTypeException : SystemException { 

        public SqlTypeException() : this(Res.GetString(Res.SqlMisc_SqlTypeMessage), null) { // MDAC 82931, 84941 
        } 

        // Creates a new SqlTypeException with its message string set to message. 
        public SqlTypeException(String message) : this(message, null) {
        }

        public SqlTypeException(String message, Exception e) : base(message, e) { // MDAC 82931 
            HResult = HResults.SqlType; // MDAC 84941
        } 
 
        // runtime will call even if private...
        //  
        protected SqlTypeException(SerializationInfo si, StreamingContext sc) : base(SqlTypeExceptionSerialization(si, sc), sc) {
        }

        static private SerializationInfo SqlTypeExceptionSerialization(SerializationInfo si, StreamingContext sc) { 
            if ((null != si) && (1 == si.MemberCount)) {
                string message = si.GetString("SqlTypeExceptionMessage"); // WebData 104331 
                SqlTypeException fakeValue = new SqlTypeException(message); 
                fakeValue.GetObjectData(si, sc);
            } 
            return si;
        }
    } // SqlTypeException
 
    [Serializable]
    public sealed class SqlNullValueException : SqlTypeException { 
 
        // Creates a new SqlNullValueException with its message string set to the common string.
        public SqlNullValueException() : this(SQLResource.NullValueMessage, null) { 
        }

        // Creates a new NullValueException with its message string set to message.
        public SqlNullValueException(String message) : this(message, null) { 
        }
 
        public SqlNullValueException(String message, Exception e) : base(message, e) { // MDAC 82931 
            HResult = HResults.SqlNullValue; // MDAC 84941
        } 

        // runtime will call even if private...
        // 
        private SqlNullValueException(SerializationInfo si, StreamingContext sc) : base(SqlNullValueExceptionSerialization(si, sc), sc) { 
        }
 
        static private SerializationInfo SqlNullValueExceptionSerialization(SerializationInfo si, StreamingContext sc) { 
            if ((null != si) && (1 == si.MemberCount)) {
                string message = si.GetString("SqlNullValueExceptionMessage"); // WebData 104331 
                SqlNullValueException fakeValue = new SqlNullValueException(message);
                fakeValue.GetObjectData(si, sc);
            }
            return si; 
        }
    } // NullValueException 
 
    [Serializable]
    public sealed class SqlTruncateException : SqlTypeException { 

        // Creates a new SqlTruncateException with its message string set to the empty string.
        public SqlTruncateException() : this(SQLResource.TruncationMessage, null) {
        } 

        // Creates a new SqlTruncateException with its message string set to message. 
        public SqlTruncateException(String message) : this(message, null) { 
        }
 
        public SqlTruncateException(String message, Exception e) : base(message, e) { // MDAC 82931
            HResult = HResults.SqlTruncate; // MDAC 84941
        }
 
        // runtime will call even if private...
        //  
        private SqlTruncateException(SerializationInfo si, StreamingContext sc) : base(SqlTruncateExceptionSerialization(si, sc), sc) { 
        }
 
        static private SerializationInfo SqlTruncateExceptionSerialization(SerializationInfo si, StreamingContext sc) {
            if ((null != si) && (1 == si.MemberCount)) {
                string message = si.GetString("SqlTruncateExceptionMessage"); // WebData 104331
                SqlTruncateException fakeValue = new SqlTruncateException(message); 
                fakeValue.GetObjectData(si, sc);
            } 
            return si; 
        }
    } // SqlTruncateException 

 	[Serializable]
    public sealed class SqlNotFilledException : SqlTypeException {
		// 
 
 
		// Creates a new SqlNotFilledException with its message string set to the common string. 
		public SqlNotFilledException() : this(SQLResource.NotFilledMessage, null) {
		} 

 		// Creates a new NullValueException with its message string set to message.
		public SqlNotFilledException(String message) : this(message, null) {
        } 

 		public SqlNotFilledException(String message, Exception e) : base(message, e) { // MDAC 82931 
 			HResult = HResults.SqlNullValue; // MDAC 84941 
		}
 
 		// runtime will call even if private...
		// 
		private SqlNotFilledException(SerializationInfo si, StreamingContext sc) : base(si, sc) {
		} 
 	} // SqlNotFilledException
 
	[Serializable] 
    public sealed class SqlAlreadyFilledException : SqlTypeException {
 		// 
 

		// Creates a new SqlNotFilledException with its message string set to the common string.
 		public SqlAlreadyFilledException() : this(SQLResource.AlreadyFilledMessage, null) { 
		}
 
		// Creates a new NullValueException with its message string set to message. 
		public SqlAlreadyFilledException(String message) : this(message, null) {
        } 

 		public SqlAlreadyFilledException(String message, Exception e) : base(message, e) { // MDAC 82931
			HResult = HResults.SqlNullValue; // MDAC 84941
 		} 

 		// runtime will call even if private... 
		//  
 		private SqlAlreadyFilledException(SerializationInfo si, StreamingContext sc) : base(si, sc) {
		} 
	} // SqlNotFilledException

	
    internal sealed class SQLDebug { 
        private SQLDebug() { /* prevent utility class from being insantiated*/ }
 
        [System.Diagnostics.Conditional("DEBUG")] 
        internal static void Check(bool condition) {
            Debug.Assert(condition, "", ""); 
        }

        [System.Diagnostics.Conditional("DEBUG")]
        internal static void Check(bool condition, String conditionString, string message) { 
            Debug.Assert(condition, conditionString, message);
        } 
 
        [System.Diagnostics.Conditional("DEBUG")]
        internal static void Check(bool condition, String conditionString) { 
            Debug.Assert(condition, conditionString, "");
        }

        /* 
        [System.Diagnostics.Conditional("DEBUG")]
        internal static void Message(String traceMessage) { 
            Debug.WriteLine(SQLResource.MessageString + ": " + traceMessage); 
        }
        */ 

    } // SQLDebug

#if WINFSFunctionality 
    internal static class SQLUtility {
        internal static object GetLOBFromCookie(byte[] cookie, SqlConnection connection, SqlTransaction transaction) { 
            // Error checking??? 
            SqlCommand command = connection.CreateCommand();
            command.CommandText = "sp_fetchLOBfromcookie"; 

            if (transaction != null)
                command.Transaction = transaction;
 
            command.CommandType = CommandType.StoredProcedure;
 
            SqlParameter parameter = command.Parameters.Add("@cookie", SqlDbType.VarBinary); 
            parameter.Direction = ParameterDirection.Input;
            parameter.Value     = cookie; 
            parameter.Size      = -1;

            return command.ExecuteScalar();
        } 
    }
#endif 
} // namespace System.Data.SqlTypes 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//------------------------------------------------------------------------------ 
// 
//     Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// junfang 
// [....]
// [....] 
//----------------------------------------------------------------------------- 

//************************************************************************* 
// @File: SQLUtility.cs
//
// Create by:	JunFang
// 
// Purpose: Implementation of utilities in COM+ SQL Types Library.
//			Includes interface INullable, exceptions SqlNullValueException 
//			and SqlTruncateException, and SQLDebug class. 
//
// Notes: 
//
// History:
//
//   09/17/99  JunFang	Created and implemented as first drop. 
//
// @EndHeader@ 
//************************************************************************* 

using System; 
using System.Data.Sql;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Globalization; 
using System.Runtime.Serialization;
 
namespace System.Data.SqlTypes { 

    internal enum EComparison { 
        LT,
        LE,
        EQ,
        GE, 
        GT,
        NE 
    } 

 	// This enumeration is used to inquire about internal storage of a SqlBytes or SqlChars instance: 
    public enum StorageState {
		Buffer = 0,
		Stream = 1,
#if WINFSFunctionality 
		UnmanagedBuffer = 2,
 		Delayed = 3 
#else 
		UnmanagedBuffer = 2
#endif 
 	}

    [Serializable]
    public class SqlTypeException : SystemException { 

        public SqlTypeException() : this(Res.GetString(Res.SqlMisc_SqlTypeMessage), null) { // MDAC 82931, 84941 
        } 

        // Creates a new SqlTypeException with its message string set to message. 
        public SqlTypeException(String message) : this(message, null) {
        }

        public SqlTypeException(String message, Exception e) : base(message, e) { // MDAC 82931 
            HResult = HResults.SqlType; // MDAC 84941
        } 
 
        // runtime will call even if private...
        //  
        protected SqlTypeException(SerializationInfo si, StreamingContext sc) : base(SqlTypeExceptionSerialization(si, sc), sc) {
        }

        static private SerializationInfo SqlTypeExceptionSerialization(SerializationInfo si, StreamingContext sc) { 
            if ((null != si) && (1 == si.MemberCount)) {
                string message = si.GetString("SqlTypeExceptionMessage"); // WebData 104331 
                SqlTypeException fakeValue = new SqlTypeException(message); 
                fakeValue.GetObjectData(si, sc);
            } 
            return si;
        }
    } // SqlTypeException
 
    [Serializable]
    public sealed class SqlNullValueException : SqlTypeException { 
 
        // Creates a new SqlNullValueException with its message string set to the common string.
        public SqlNullValueException() : this(SQLResource.NullValueMessage, null) { 
        }

        // Creates a new NullValueException with its message string set to message.
        public SqlNullValueException(String message) : this(message, null) { 
        }
 
        public SqlNullValueException(String message, Exception e) : base(message, e) { // MDAC 82931 
            HResult = HResults.SqlNullValue; // MDAC 84941
        } 

        // runtime will call even if private...
        // 
        private SqlNullValueException(SerializationInfo si, StreamingContext sc) : base(SqlNullValueExceptionSerialization(si, sc), sc) { 
        }
 
        static private SerializationInfo SqlNullValueExceptionSerialization(SerializationInfo si, StreamingContext sc) { 
            if ((null != si) && (1 == si.MemberCount)) {
                string message = si.GetString("SqlNullValueExceptionMessage"); // WebData 104331 
                SqlNullValueException fakeValue = new SqlNullValueException(message);
                fakeValue.GetObjectData(si, sc);
            }
            return si; 
        }
    } // NullValueException 
 
    [Serializable]
    public sealed class SqlTruncateException : SqlTypeException { 

        // Creates a new SqlTruncateException with its message string set to the empty string.
        public SqlTruncateException() : this(SQLResource.TruncationMessage, null) {
        } 

        // Creates a new SqlTruncateException with its message string set to message. 
        public SqlTruncateException(String message) : this(message, null) { 
        }
 
        public SqlTruncateException(String message, Exception e) : base(message, e) { // MDAC 82931
            HResult = HResults.SqlTruncate; // MDAC 84941
        }
 
        // runtime will call even if private...
        //  
        private SqlTruncateException(SerializationInfo si, StreamingContext sc) : base(SqlTruncateExceptionSerialization(si, sc), sc) { 
        }
 
        static private SerializationInfo SqlTruncateExceptionSerialization(SerializationInfo si, StreamingContext sc) {
            if ((null != si) && (1 == si.MemberCount)) {
                string message = si.GetString("SqlTruncateExceptionMessage"); // WebData 104331
                SqlTruncateException fakeValue = new SqlTruncateException(message); 
                fakeValue.GetObjectData(si, sc);
            } 
            return si; 
        }
    } // SqlTruncateException 

 	[Serializable]
    public sealed class SqlNotFilledException : SqlTypeException {
		// 
 
 
		// Creates a new SqlNotFilledException with its message string set to the common string. 
		public SqlNotFilledException() : this(SQLResource.NotFilledMessage, null) {
		} 

 		// Creates a new NullValueException with its message string set to message.
		public SqlNotFilledException(String message) : this(message, null) {
        } 

 		public SqlNotFilledException(String message, Exception e) : base(message, e) { // MDAC 82931 
 			HResult = HResults.SqlNullValue; // MDAC 84941 
		}
 
 		// runtime will call even if private...
		// 
		private SqlNotFilledException(SerializationInfo si, StreamingContext sc) : base(si, sc) {
		} 
 	} // SqlNotFilledException
 
	[Serializable] 
    public sealed class SqlAlreadyFilledException : SqlTypeException {
 		// 
 

		// Creates a new SqlNotFilledException with its message string set to the common string.
 		public SqlAlreadyFilledException() : this(SQLResource.AlreadyFilledMessage, null) { 
		}
 
		// Creates a new NullValueException with its message string set to message. 
		public SqlAlreadyFilledException(String message) : this(message, null) {
        } 

 		public SqlAlreadyFilledException(String message, Exception e) : base(message, e) { // MDAC 82931
			HResult = HResults.SqlNullValue; // MDAC 84941
 		} 

 		// runtime will call even if private... 
		//  
 		private SqlAlreadyFilledException(SerializationInfo si, StreamingContext sc) : base(si, sc) {
		} 
	} // SqlNotFilledException

	
    internal sealed class SQLDebug { 
        private SQLDebug() { /* prevent utility class from being insantiated*/ }
 
        [System.Diagnostics.Conditional("DEBUG")] 
        internal static void Check(bool condition) {
            Debug.Assert(condition, "", ""); 
        }

        [System.Diagnostics.Conditional("DEBUG")]
        internal static void Check(bool condition, String conditionString, string message) { 
            Debug.Assert(condition, conditionString, message);
        } 
 
        [System.Diagnostics.Conditional("DEBUG")]
        internal static void Check(bool condition, String conditionString) { 
            Debug.Assert(condition, conditionString, "");
        }

        /* 
        [System.Diagnostics.Conditional("DEBUG")]
        internal static void Message(String traceMessage) { 
            Debug.WriteLine(SQLResource.MessageString + ": " + traceMessage); 
        }
        */ 

    } // SQLDebug

#if WINFSFunctionality 
    internal static class SQLUtility {
        internal static object GetLOBFromCookie(byte[] cookie, SqlConnection connection, SqlTransaction transaction) { 
            // Error checking??? 
            SqlCommand command = connection.CreateCommand();
            command.CommandText = "sp_fetchLOBfromcookie"; 

            if (transaction != null)
                command.Transaction = transaction;
 
            command.CommandType = CommandType.StoredProcedure;
 
            SqlParameter parameter = command.Parameters.Add("@cookie", SqlDbType.VarBinary); 
            parameter.Direction = ParameterDirection.Input;
            parameter.Value     = cookie; 
            parameter.Size      = -1;

            return command.ExecuteScalar();
        } 
    }
#endif 
} // namespace System.Data.SqlTypes 

// 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

• BindingWorker.cs
• Page.cs
• WpfSharedXamlSchemaContext.cs
• IsolatedStorageFileStream.cs
• WorkflowMarkupSerializationProvider.cs
• ControlParameter.cs
• EnglishPluralizationService.cs
• ConstructorNeedsTagAttribute.cs
• DataGridColumn.cs
• XmlUtil.cs
• IsolationInterop.cs
• ResponseStream.cs
• CategoryAttribute.cs
• XsdValidatingReader.cs
• DbExpressionVisitor_TResultType.cs
• OdbcRowUpdatingEvent.cs
• GradientSpreadMethodValidation.cs
• Repeater.cs
• ToolStripContentPanelDesigner.cs
• MonitoringDescriptionAttribute.cs
• LineMetrics.cs
• BuildProvider.cs
• ResXDataNode.cs
• ThumbAutomationPeer.cs
• AsymmetricSignatureFormatter.cs
• NavigationService.cs
• NavigatorOutput.cs
• CodeMethodInvokeExpression.cs
• TopClause.cs
• AutomationPatternInfo.cs
• XmlDownloadManager.cs
• CodeMemberMethod.cs
• TransformGroup.cs
• CancelEventArgs.cs
• EntityObject.cs
• SpeechDetectedEventArgs.cs
• IPGlobalProperties.cs
• NameNode.cs
• AuthenticationException.cs
• VoiceChangeEventArgs.cs
• SecurityUtils.cs
• IDReferencePropertyAttribute.cs
• Bezier.cs
• WebReference.cs
• DataContractSet.cs
• OleDbFactory.cs
• Internal.cs
• UnicastIPAddressInformationCollection.cs
• coordinatorfactory.cs
• BitmapImage.cs
• COM2ExtendedUITypeEditor.cs
• SystemDropShadowChrome.cs
• ParseHttpDate.cs
• PageHandlerFactory.cs
• ChannelFactoryBase.cs
• SchemaImporterExtensionElementCollection.cs
• EditorBrowsableAttribute.cs
• DataGridCellsPresenter.cs
• MailDefinition.cs
• ParserContext.cs
• SoapUnknownHeader.cs
• SignatureConfirmationElement.cs
• TemplateField.cs
• ImageAnimator.cs
• ContentElementAutomationPeer.cs
• Emitter.cs
• ValueQuery.cs
• Variant.cs
• DesignerMetadata.cs
• SparseMemoryStream.cs
• ListSourceHelper.cs
• ZipIOExtraFieldPaddingElement.cs
• ListViewCommandEventArgs.cs
• newitemfactory.cs
• EndCreateSecurityTokenRequest.cs
• RestClientProxyHandler.cs
• ListViewTableCell.cs
• unsafeIndexingFilterStream.cs
• ForceCopyBuildProvider.cs
• Rect.cs
• SimplePropertyEntry.cs
• PeerHopCountAttribute.cs
• NumericExpr.cs
• ProgressBar.cs
• CanonicalizationDriver.cs
• TableRow.cs
• HttpPostProtocolReflector.cs
• SqlDataAdapter.cs
• XXXOnTypeBuilderInstantiation.cs
• AssemblyAttributesGoHere.cs
• JsonFormatReaderGenerator.cs
• CodeCommentStatementCollection.cs
• FontNameEditor.cs
• BlobPersonalizationState.cs
• TemplateField.cs
• ArgumentOutOfRangeException.cs
• ExpressionWriter.cs
• UnsafeNativeMethods.cs
• CompressEmulationStream.cs
• WebPartMenu.cs