SQLUtility.cs source code in C# .NET

                        
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 / SQLTypes / SQLUtility.cs / 1 / 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

• TableLayoutStyle.cs
• ProfessionalColors.cs
• IconBitmapDecoder.cs
• AppLevelCompilationSectionCache.cs
• ExpressionVisitor.cs
• CheckBox.cs
• StorageBasedPackageProperties.cs
• StateWorkerRequest.cs
• CapabilitiesRule.cs
• PagesSection.cs
• TargetException.cs
• Events.cs
• ManagementInstaller.cs
• RadioButton.cs
• DataGridRow.cs
• SoapHeaderAttribute.cs
• CodeGeneratorAttribute.cs
• FixedSOMImage.cs
• StoreItemCollection.cs
• Int32AnimationUsingKeyFrames.cs
• Gdiplus.cs
• DesignerVerb.cs
• Mutex.cs
• RemoteHelper.cs
• ServiceThrottlingElement.cs
• PenContext.cs
• DelimitedListTraceListener.cs
• SystemDropShadowChrome.cs
• ScrollableControlDesigner.cs
• LogPolicy.cs
• UserControl.cs
• DataSourceControl.cs
• ConfigXmlSignificantWhitespace.cs
• InkCanvasAutomationPeer.cs
• SynchronizedInputAdaptor.cs
• CheckableControlBaseAdapter.cs
• DoubleAnimationUsingKeyFrames.cs
• HandlerFactoryCache.cs
• X509SecurityTokenAuthenticator.cs
• Closure.cs
• CodeTypeOfExpression.cs
• DictionarySectionHandler.cs
• SelectionWordBreaker.cs
• SettingsBindableAttribute.cs
• MDIWindowDialog.cs
• DataGridViewRowsRemovedEventArgs.cs
• ISFClipboardData.cs
• AccessorTable.cs
• PageHandlerFactory.cs
• MiniConstructorInfo.cs
• FormsAuthenticationModule.cs
• ObjectFactoryCodeDomTreeGenerator.cs
• BypassElementCollection.cs
• DesignerDataSourceView.cs
• DocumentViewerConstants.cs
• Encoder.cs
• DesignerLoader.cs
• ImageAttributes.cs
• ButtonStandardAdapter.cs
• TextModifierScope.cs
• Command.cs
• FontNameEditor.cs
• BrushConverter.cs
• ListBase.cs
• DbProviderFactoriesConfigurationHandler.cs
• CurrentChangingEventManager.cs
• SqlConnectionPoolProviderInfo.cs
• Mutex.cs
• ExecutionProperties.cs
• SrgsGrammar.cs
• JavaScriptString.cs
• Clock.cs
• SupportsEventValidationAttribute.cs
• HyperLinkStyle.cs
• GetWinFXPath.cs
• StaticContext.cs
• DataViewManager.cs
• ApplicationInterop.cs
• MimeTypePropertyAttribute.cs
• MarkupProperty.cs
• DefaultWorkflowSchedulerService.cs
• JsonWriter.cs
• SqlProviderServices.cs
• AssemblyAssociatedContentFileAttribute.cs
• BitmapSource.cs
• MarshalByRefObject.cs
• WebReferencesBuildProvider.cs
• BindStream.cs
• BooleanSwitch.cs
• ToolboxItemCollection.cs
• SafeArrayRankMismatchException.cs
• DataKey.cs
• DuplexChannelFactory.cs
• ProfileGroupSettings.cs
• MatrixCamera.cs
• DragEventArgs.cs
• SqlServer2KCompatibilityCheck.cs
• SoapFault.cs
• XmlSecureResolver.cs
• MarkupExtensionSerializer.cs