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

• XmlSchemaSimpleType.cs
• XmlSchemaCompilationSettings.cs
• DataBindingHandlerAttribute.cs
• ReliableMessagingHelpers.cs
• XmlCompatibilityReader.cs
• CoreSwitches.cs
• OrderedDictionary.cs
• ActivityTypeDesigner.xaml.cs
• LogSwitch.cs
• Region.cs
• UseAttributeSetsAction.cs
• PermissionListSet.cs
• Pens.cs
• XmlStringTable.cs
• ListDictionaryInternal.cs
• ZipIOLocalFileDataDescriptor.cs
• CompilerInfo.cs
• HashMembershipCondition.cs
• EdgeModeValidation.cs
• ManagementQuery.cs
• SuppressMergeCheckAttribute.cs
• NumericUpDownAccelerationCollection.cs
• IPCCacheManager.cs
• SyncOperationState.cs
• SrgsText.cs
• ToolboxCategory.cs
• securestring.cs
• AlignmentXValidation.cs
• TemplateBaseAction.cs
• Command.cs
• EdmSchemaAttribute.cs
• COM2ExtendedBrowsingHandler.cs
• XmlReaderDelegator.cs
• dataprotectionpermission.cs
• TaiwanLunisolarCalendar.cs
• DecoderNLS.cs
• TypefaceCollection.cs
• UnicastIPAddressInformationCollection.cs
• OleDbParameterCollection.cs
• PasswordRecovery.cs
• sqlpipe.cs
• NativeObjectSecurity.cs
• SimplePropertyEntry.cs
• PagesSection.cs
• XamlSerializerUtil.cs
• ToolStripItemCollection.cs
• OperationValidationEventArgs.cs
• ContextMenu.cs
• TriggerBase.cs
• ButtonColumn.cs
• AttributeParameterInfo.cs
• CommonProperties.cs
• ListBindingConverter.cs
• LinqDataSourceView.cs
• ToolStripItemImageRenderEventArgs.cs
• InvokeDelegate.cs
• UniqueEventHelper.cs
• ChameleonKey.cs
• TypeGeneratedEventArgs.cs
• DomainUpDown.cs
• CompressedStack.cs
• PackageRelationshipSelector.cs
• StrokeIntersection.cs
• ActivityMarkupSerializer.cs
• XmlSchemaParticle.cs
• FormsAuthenticationCredentials.cs
• ConfigXmlWhitespace.cs
• ServiceDocumentFormatter.cs
• AnimatedTypeHelpers.cs
• RoleManagerModule.cs
• SecurityDescriptor.cs
• RequestCachingSection.cs
• ApplicationFileCodeDomTreeGenerator.cs
• GenericsInstances.cs
• StoryFragments.cs
• XmlSchemaValidator.cs
• HttpCacheParams.cs
• MenuItem.cs
• ProfileSection.cs
• FullTextLine.cs
• HttpChannelFactory.cs
• Shared.cs
• JsonReaderDelegator.cs
• CodeExpressionStatement.cs
• LinearQuaternionKeyFrame.cs
• MembershipSection.cs
• FixedSOMTable.cs
• LocalFileSettingsProvider.cs
• NamedObject.cs
• RuntimeWrappedException.cs
• CodeRegionDirective.cs
• DirectoryLocalQuery.cs
• GridEntryCollection.cs
• TypeListConverter.cs
• OleStrCAMarshaler.cs
• DataMisalignedException.cs
• DependencySource.cs
• SystemFonts.cs
• StringBuilder.cs
• AssemblyAssociatedContentFileAttribute.cs